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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy