• charipg (7/29/2009)


    what is fillfactor and what are the advantages and disadvantages?

    Refer this BOL link to know about fill factor.

    http://msdn.microsoft.com/en-us/library/ms177459.aspx%5B/url%5D

    A fill factor of 30 means 30% of space within the data page will be kept vacant, so that when you insert more rows later, they would be accomodated within this free space. This means sql server will not ask for new pages to accomodate your data every time you insert and hence pages will be contiguous, leading to better performance.



    Pradeep Singh