June 2, 2008 at 1:36 pm
What would be the best way to determine a apprioprate fill factor for you indexes?
Thanks,
Art
Database Analyst
Tastefully Simple, Inc.
alorenzini@tastefullysimple.com
" Some days, it's not even worth chewing through the restraints!
June 2, 2008 at 1:50 pm
It is really a case-by-case question. Here is a link for your reference. May it help.
http://msdn.microsoft.com/en-us/library/aa933139(SQL.80).aspx
June 2, 2008 at 2:02 pm
general rule: more updates (in a timeframe), means creating/rebuilding with a lower fillfactor. Thus, for read-only data, set filfactor to 100. (fillfactor is the amount of free space in a page)
For example: If you see that an index is a candidate for a rebuild every day, lower the fillfactor.
Wilfred
The best things in life are the simple things
June 2, 2008 at 2:18 pm
Great info. The article really help.
Thanks,
Art
Database Analyst
Tastefully Simple, Inc.
alorenzini@tastefullysimple.com
" Some days, it's not even worth chewing through the restraints!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply