Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Adding records to a table
Message
De
19/04/2001 14:00:19
 
 
À
19/04/2001 12:43:29
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00497112
Message ID:
00497466
Vues:
9
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform