Fill factor = 100 fills the pages completely.
Fill factor = 0 leaves space in the index non-leaf pages .
Source
Related posts
Add comment
History
SQL SERVER DATABASE ADMINISTRATOR, DEVELOPER, began working with computers in 1980. Specializing in MS SQL Server 2000, 2005, Transact SQL, Stored Procedures, DTS.