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

  1. In Object Explorer, right-click a server and select Properties.

  2. Click the Database settings node.

  3. In the Default index fill factor box, type or select the desired index fill factor.

See Also