🛢DBMS: Fill Factor (Definitions)

"An option that specifies how full SQL Server should make each index page. The amount of empty space on an index page is important because when an index page fills up, the system must take time to split it to make room for new rows." (Patrick Dalton, "Microsoft SQL Server Black Book", 1997)

"Specifies to SQL server how full an index page should be." (Owen Williams, "MCSE TestPrep: SQL Server 6.5 Design and Implementation", 1998)

"An option used when creating an index to reserve free space on each page of the index. This option accommodates future expansion of table data and reduces the potential for page splits. It is a percentage from 0 through 100 that specifies how much of the data pages should be filled after the index is created." (Microsoft Corporation, "SQL Server 7.0 System Administration Training Kit", 1999)

"The fill factor value is a percentage from 0 to 100 that specifies how much to fill the data pages after the index is created. A fill factor value of 0 does not mean that index pages are left empty but rather that only the leaf pages are filled." (Microsoft Corporation, "Microsoft SQL Server 7.0 Data Warehouse Training Kit", 2000)

"Fill factor defines the amount of free space on each page of the index. You use fill factor when creating indexes. It accommodates future expansion of table data and reduces the potential for page splits." (Anthony Sequeira & Brian Alderman, "The SQL Server 2000 Book", 2003)

"An attribute of an index that defines the amount of free space allotted to each page of the index. FILLFACTOR can be used to allocate space for future expansion. FILLFACTOR is a value from 1 through 100 that specifies the percentage of the index page to be left empty." (Thomas Moore, "EXAM CRAM™ 2: Designing and Implementing Databases with SQL Server 2000 Enterprise Edition", 2005)

"The fill factor of an index indicates how much space to leave open for new data when the index is reorganized during maintenance." (Joseph L Jorden & Dandy Weyn, "MCTS Microsoft SQL Server 2005: Implementation and Maintenance Study Guide - Exam 70-431", 2006)

"An index option that identifies how full an index will be when it is created. For tables that have a lot of INSERTS, setting an indexes fill factor to something other than 0 (indicating 100 percent full) will prevent excessive page splits and the resulting fragmentation of indexes." (Darril Gibson, "MCITP SQL Server 2005 Database Developer All-in-One Exam Guide", 2008)

"An attribute of an index that defines how full the SQL Server Database Engine should make each page of the index." (Microsoft, "SQL Server 2012 Glossary", 2012)