SQL SERVER – What is Fill Factor and What is the Best Value for Fill Factor
- by pinaldave
Working in performance tuning area, one has to know about Index and Index Maintenance. For any Index the most important property is Fill Factor.
Fill factor is the value that determines the percentage of space on each leaf-level page to be filled with data. In an SQL Server, the smallest unit is a page, which is made of Page with size 8K.…