Skip to main content
Question

SQL filegroups without using partitioning

  • March 22, 2018
  • 0 replies
  • 0 views

Forum|alt.badge.img

How can we configure TX to create non clusted indexes to  filegroup 1 and depending on the type of table create the table on filegroup 2, 3 or 4?

We are running SQL 2008 R2 standard so we don't have the partitioning features.