Home Forums Article Discussions Article Discussions by Author Discuss content posted by Raj Gujar Moving Large Table to Different File Group RE: Moving Large Table to Different File Group
Richard Fryar
Hall of Fame
Points: 3457
More actions
October 16, 2008 at 9:25 am
#885922
When you created the new file in the new filegroup you set a very small initial size with small growth increment.
To avoid excess fragmentation, you should set the initial size so it is big enough for the new data, and for medium term future growth.
Check Your SQL Servers Quickly and Easilywww.sqlcopilot.com