SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2008 R2
Product Documentation
SQL Server 2008 R2 Books Online
Database Engine
Operations
Administration (Database Engine)
Administration: How-to Topics (Database Engine)
Server Management How-to Topics
Server Configuration How-to Topics
How to: View Server Properties (SQL Server Management Studio)
How to: Check and Set Remote Server Connection Options (SQL Server Management Studio)
How to: View or Change Server Properties (SQL Server Configuration Manager)
How to: Configure the Affinity Mask (SQL Server Management Studio)
How to: Configure the awe enabled Option (SQL Server Management Studio)
How to: Configure the c2 audit mode Option (SQL Server Management Studio)
How to: View or Change the backup compression default Option (SQL Server Management Studio)
How to: View or Change the Default Locations for Data and Log Files (SQL Server Management Studio)
How to: Configure the cost threshold for parallelism Option (SQL Server Management Studio)
How to: Configure the cursor threshold Option (SQL Server Management Studio)
How to: Set the Default Full-Text Language (SQL Server Management Studio)
How to: Set the Default Language (SQL Server Management Studio)
How to: Set a Fixed Fill Factor (SQL Server Management Studio)
How to: Configure the index create memory Option (SQL Server Management Studio)
How to: Configure the locks Option (SQL Server Management Studio)
How to: Configure the Number of Processors Available for Parallel Queries (SQL Server Management Studio)
How to: Set Minimum Query Memory (SQL Server Management Studio)
How to: Configure the Maximum Number of Worker Threads (SQL Server Management Studio)
How to: Set the Backup Retention Duration (SQL Server Management Studio)
How to: Set a Fixed Amount of Memory (SQL Server Management Studio)
How to: Configure the max text repl size Option (SQL Server Management Studio)
How to: Configure the nested triggers Option (SQL Server Management Studio)
How to: Configure the priority boost Option (SQL Server Management Studio)
How to: Set the Recovery Interval (SQL Server Management Studio)
How to: Set Remote Server Access (SQL Server Management Studio)
How to: Set Remote Login Timeout (SQL Server Management Studio)
How to: Configure the scan for startup procs Option (SQL Server Management Studio)
How to: Enforce Distributed Transactions for Remote Procedures (SQL Server Management Studio)
How to: Set a Time Limit for Remote Queries (SQL Server Management Studio)
How to: Configure the two-digit year cutoff Option (SQL Server Management Studio)
How to: Set User Connections (SQL Server Management Studio)
How to: Configure User Options (SQL Server Management Studio)
How to: Configure Packet Size (SQL Server Management Studio)
How to: Configure the query governor cost limit Option (SQL Server Management Studio)
How to: Configure the query wait Option (SQL Server Management Studio)
How to: Enable the Lock Pages in Memory Option (Windows)
How to: Map TCP/IP Ports to NUMA Nodes
How to: Configure SQL Server to Use Soft-NUMA
Expand Minimize
This topic has not yet been rated - Rate this topic

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

SQL Server 2008 R2

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

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.