fill factor Option

This option sets the server-wide default fill-factor value. Fill factor is provided for fine-tuning index data storage and performance. When an index is created or rebuilt, the fill-factor value determines the percentage of space on each leaf-level page to be filled with data, reserving the rest as free space for future growth. For more information, see Fill Factor.

Examples

A. Setting the fill factor server configuration option

The following example shows how to use sp_configureto set the fill factor server configuration option to 100. Using sp_configure, you can change fill factor only when show advanced options is set to 1. The setting takes effect after restarting the server. For more information, see Setting Server Configuration Options.

Use AdventureWorks;
GO
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'fill factor', 100;
GO
RECONFIGURE;
GO