Tag Info

New answers tagged

1

1) Yes 2) Yes, After creating the new files, you'll need to drop and re-create the clustered indexes of the target tables, moving them on to the new filegroup to move the data: CREATE CLUSTERED INDEX CIX_YourTable ON dbo.YourTable(YourClusteringKeyFields) WITH DROP_EXISTING ON [filegroup_name] 3) If you can get the DBA to back you up on this solution, ...


1

The 3rd method does not have performance advantages. There are two reasons I can think of that one would be doing this: You plan to spread files to multiple disks later (move to option 1) You would have allocation contention with just one file. This is a common problem with high-load tempdb's. It is rare with user databases. Multiple files on the same ...



Top 50 recent answers are included