Default Fill Factor

By default, SQL Server uses a fill factor of 100% for the pages in index files. Although there are some cases where having a lower fill factor can improve performance, this should be implemented on an index-by-index basis. Setting an incorrect database-wide fill factor will mean indexes that don't need a lower fill factor will use more storage space and perform worse.

Suggested Action

Change the default fill factor back to the default of 100 (or zero, which SQL Server treats as the same thing).

Any suggestion from Aireforge should be thoroughly tested before being implemented into production.