Export (0) Print
Expand All
Expand Minimize
0 out of 2 rated this helpful - Rate this topic

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.

  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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.