Fill Factor | SQL Server Performance Forums

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 this link by Kalen for further information. Satya SKJ
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
Also there is a lot of information in this forum, use search in top page.
Luis Martin
Moderator 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=></a><br />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=></a>) <br />