• ctsufer31 - Tuesday, March 6, 2018 9:05 PM

    I believe I have found a solution to my issue. There are two articles that someone has directed me to:
    What is Fill Factor? Index, Fill Factor and Performance, Part 1
    What is the Best Value for the Fill Factor? Index, Fill Factor and Performance, Part 2
    Both articles give a complete overview of fill factor and possible solutions to what values to use.

    Hmm, not really educational articles.
    This:

    Fill Factor (100 or 0) will allow the SQL Server to fill the leaf-level pages of an index with the maximum numbers of the rows it can fit.

    is totally misleading.
    Fillfactor value does not allow or disallow SQL Server to fill up the pages in any particular way.
    It will always try to fill pages in the most effective way (well, according to its internal algorythms).

    This

    Fill factor is usually measured at the server level as well as table level.

    is pretty much rubbish.
    On the server level there is a default value of fill factor. Which may not match any of actuall fill factor values for any index anywhere accross the server.
    And fill factor on a table level is simply a nonsense.

    Don't put too much faith in those articles.

    _____________
    Code for TallyGenerator