Purpose

The purpose of this article is to teach you the process of setting up the fixed fill factor in Microsoft SQL Server 2000.

Setting a Fixed Fill Factor

Fill factor option is used to specify how full Microsoft SQL Server should make each page when it creates a new index using existing data. The fill factor percentage affects performance because SQL Server must take time to split pages when they fill up. The fill factor percentage is used only at the time the index is created. The pages are not maintained at any particular level of fullness. The default for fill factor is 0; valid values range from 0 through 100.

Following steps describe you the process of setting up a fixed fill factor:

1. Click Start, go to Programs, then go to Microsoft SQL Server and click Enterprise Manager.

2. Right click registered server i.e. PC54, click Properties and then select Database Setting tab.

3. Select the Fixed option under Settings, then set a value for fill factor from 0 to 100.

4. Click OK, and then click Yes.