ctsufer31 - Tuesday, March 6, 2018 9:05 PM
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