If you make significant changes to space management property values, the table copy can be considerably larger or smaller than the original table. Settings for space management properties are stored in the sysindexes tables, and are displayed by sp_help and sp_helpindex. This output shows the space management properties for the titles table:
exp_row_size reservepagegap fillfactor max_rows_per_page
------------ -------------- ---------- -----------------
190 16 90 0
sp_helpindex produces this report:
index_name index_description
index_keys
index_max_rows_per_page index_fillfactor index_reservepagegap
----------------------- ---------------- --------------------
title_id_ix nonclustered located on default
title_id
0 75 0
title_ix nonclustered located on default
title
0 80 16
type_price nonclustered located on default
type, price
0 90 0
