SQL Server Performance Forum – Threads Archive
Fill Factorcan 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
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
Also there is a lot of information in this forum, use search in top page.
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
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 />