June 15, 2011 at 5:11 pm
When doing alert index statement, what fillfactor should we use, use the default 0 or use 90?
What is the advantages and disadvantages for the above 2?
Also SORT_IN_TEMPDB = ON or off, which is better option ?
Thanks
June 15, 2011 at 5:17 pm
Setting fillfactor is how you leave some space for new rows on an index. If you alter/rebuild an index with a fillfactor of 80 it will leave 20 percent of each page open for inserting new rows. This can reduce the amount of page splitting occurring during inserts to the table.
June 15, 2011 at 5:28 pm
Setting fillfactor can be of benefit to your system but could also be a detriment. It's not something you should set all one way or the other. You should understand the operations being performed most frequently on the table and the data in the table in order to set a proper fillfactor.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 15, 2011 at 10:44 pm
This blogs explains most of stuff in detail and good read to understand it.
http://sqlnerd.blogspot.com/2005/06/index-fill-factor-performance.html
Cheers
Sat
Cheer Satish 🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply