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:
When data is bulk-copied into the table, the reserve page gap is applied to all newly allocated space, but the storage of existing pages is not affected.
When the reorg rebuild command is run on the table, the reserve page gap is applied as the table is copied to new data pages.
When a clustered index is created, the reserve page gap value stored for the table is applied to the data pages.
The reserve page gap is applied to index pages during:
alter table...lock, while rebuilding indexes for the table
reorg rebuild commands that affect indexes
create clustered index and alter table commands that create a clustered index, as nonclustered indexes are rebuilt
