What is FILLFACTOR?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is FILLFACTOR?
Rating:
FILLFACTOR specifies a percentage that indicates how much free space will be in the leaf level of each index page. When a clustered index is created on a table, SQL Server 2005 does not stuff data wherever it finds space, but it physically rearranges data in order. SQL Server 2005 cannot rearrange data without page split if it does not find free space at an index page. To help SQL Server 2005 accomplish this, there is a need to leave a little space at the leaf level of each page on a clustered index. This free space is called FILLFACTOR.
Rating:
Was this information helpful?
Other articles
- What is the serveradmin fixed server role?
- What is the tracer token?
- What is SSL?
- Study Tips for 70-444
- What is merge replication?