Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
fill factor Option
Collapse the table of content
Expand the table of content

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.

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 AdventureWorks2008R2;
GO
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'fill factor', 100;
GO
RECONFIGURE;
GO

Community Additions

ADD
Show:
© 2015 Microsoft