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=’

‘ />] – Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de</a> Ich unterstÃ¼tze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>)

]]>