Specifying a reserve page gap with create index

This command specifies a reservepagegap of 10 for nonclustered index pages:

create index type_price_ix 
on more_titles(type, price) 
with reservepagegap = 10

You can specify a reservepagegap value with the alter table...constraint options, primary key and unique, that create indexes. The value of reservepagegap for local index on partitioned tables applies to all local index partitions.

This example creates a unique constraint:

alter table more_titles
add constraint uniq_id unique (title_id)
with reservepagegap = 20