How to: Set a Fixed Fill Factor (SQL Server Management Studio)
Use the fill factor option to specify how full Microsoft SQL Server should make each page when it creates a new index using existing data. The fill factor affects performance because SQL Server must take time to split pages when they fill up.
To set a fixed fill factor
In Object Explorer, right-click a server and select Properties.
Click the Database settings node.
In the Default index fill factor box, type or select the desired index fill factor.