The create index reference page in Chapter 1, “Commands” of Reference Manual: Commands incorrectly states that the max_rows_per_page and fillfactor parameters are exclusive.
“max_rows_per_page – max_rows_per_page and fillfactor are mutually exclusive. Unlike fillfactor, the max_rows_per_page value is maintained until it is changed with sp_chgattribute.”
It should read:
max_rows_per_page – limits the number of rows on data pages and the leaf level pages of indexes. Unlike fillfactor, the max_rows_per_page value is maintained until it is changed with sp_chgattribute.
