Home Forums SQL Server 2014 Development - SQL Server 2014 Create Index Script with Fill Factor Question RE: Create Index Script with Fill Factor Question

  • March 6, 2018 at 6:47 pm

    #1982177

    Jeff Moden - Tuesday, March 6, 2018 6:28 PM

    That's why it actually does matter.  If you have a 100% Fill Factor on a table (clustered index) or non-clustered index that suffers (like Joe Torre said above) out of order inserts or expansive updates to variable width columns and you intend to make the mistake of defragging the index based only on the percent of fragmentation

    As I said - fill factor matters only for index defragmentation.
    If it's not anywhere around the picture the number you put into FillFactor does not make any difference.
    Clustered or non-clustered, messy inserts or expansive updates - index will get exactly the same level of fragmentation with index pages sitting at the same places with the same content, with no relevance any Fillfactor value.

    _____________
    Code for TallyGenerator