How to: Set a Fixed Fill Factor (SQL Server Management Studio)

Use the fill factor option to specify how full Microsoft SQL Server 2005 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

Concepts

fill factor Option

Help and Information

Getting SQL Server 2005 Assistance