May 14, 2009 at 10:09 am
Let me paint a scenario here and ask a relatively simple question:
I am on SQL Server 2005, Ent. Ed., and I have recently added 4 more files to the Primary file group. When my nightly index rebuild runs from a Maint Plan, will it automatically rebuild the indexes (specifically the clustered indexes) of a given table across all the new files inside the file group or will it keep them in the original file?
Please let me know if I am unclear on any points.
Thanks for your help in advance.
May 18, 2009 at 10:16 am
files usually get used in a round robin way - it used to be that if you didn't create your files all at once then the extra files were ignored. Your indexes will be fine - you're probably getting confused with filegroups, where you have to allocate data to a filegroup.
I don't honestly know if a rebuild will spread your tables across the files, it may do, you'll know by monitoring file use.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply