SQL Server Performance Forum – Threads Archive
Fill Factor
can anyone please give an example for efficient use of fill factor scenario?The fill-factor value can be important in an insert-intensive environment. An index’s leaf level must maintain all the index key values in a sorted sequence, so if someone needs to insert a new row into a table, the index key value in that row determines the row’s position in the index. Creating an index with a low fill factor means that your table has room to grow before page splitting would become a cause for concern. However, if your pages are only partially filled, more pages are required to hold all your data, and the index can become quite large. Refer to thishttp://www.windowsitpro.com/SQLServer/Article/ArticleID/20242/20242.html link by Kalen for further information. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
there are plenty of content in the internet. following are some of them http://www.sqlservercentral.com/columnists/jweisbecker/amethodologyfordeterminingfillfactors.asp
http://www.sqlservercentral.com/columnists/gjackson/whocaresaboutfillfactor.asp
Also there is a lot of information in this forum, use search in top page.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS†with no warranties for accuracy.
Again, moved to a more appropriate forum. Please take care where you post your questions. Posting in the "wrong" forum might mean that you have to wait longer for a reply. [<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />]<br /><br />–<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <br />
]]>