Home Forums SQL Server 2005 Administering Table partition - Multiple filegroups vs Primary filegroup? RE: Table partition - Multiple filegroups vs Primary filegroup?

  • It's not a best practice to create user tables in the PRIMARY filegroup to begin with. Leave PRIMARY just for the system catalog, create at least one new filegroup for your user data, and then make one of the new filegroups the default for safety's sake. Now as far as partitioning goes, you need at least as many filegroups as the number of partitions your partition function would create.