Changing reservepagegap

The following command uses sp_chgattribute to change the reserve page gap for the titles table to 20:

sp_chgattribute more_titles, "reservepagegap", 20

This command sets the reserve page gap for the index title_ix to 10:

sp_chgattribute "titles.title_ix", 
    "reservepagegap", 10

sp_chgattribute changes only values in system tables; data is not moved on data pages as a result of running the procedure. Changing reservepagegap for a table affects future storage as follows:

The reserve page gap is applied to index pages during: