Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding records to a table
Message
From
19/04/2001 14:00:19
 
 
To
19/04/2001 12:43:29
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00497112
Message ID:
00497466
Views:
10
When an index is built, you can specify the fillfactor. Basically the fillfactor tells SQL Server how full to fill the leaf-level nodes of the index. The thing to remember is that SQL Server doesn't maintain the fillfactor level. Once the data pages get full, additional inserts will require spliting the page.

Check out the topic Fill Factor in the SQL Server BOL.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform