In SQL Server, the fill factor is a configuration option that determines how much space is left on each page of an index when it is created or reorganized. The fill factor specifies the percentage of space that will be filled on each page, with the remaining space left as free space. The fill factor is specified as a percentage …

Fill Factors on Indexes – What does that mean? Read more »