Using Different FILL FACTOR Values

Other values for FILL FACTOR reduce the number of rows per page on data pages and leaf index pages. To compute the correct values when using FILL FACTOR, multiply the size of the available data page (2016) by the FILL FACTOR. For example, if your FILL FACTOR is 75 percent, your data page would hold 1512 bytes. Use this value in place of 2016 in Step 2 for both clustered and nonclustered index calculations.