To add or change the expected row size for a table, us sp_chgattribute. This sets the expected row size to 190 for the new_titles table:
sp_chgattribute new_titles, "exp_row_size", 190
If you want a table to switch to the default exp_row_size percent instead of a current, explicit value, enter:
sp_chgattribute new_titles, "exp_row_size", 0
To fully pack the pages, rather than saving space for expanding rows, set the value to 1.
Changing the expected row size with sp_chgattribute does not immediately affect the storage of existing data. The new value is applied:
When a clustered index on the table is created or reorg rebuild is run on the table. The expected row size is applied as rows are copied to new data pages.
If you increase exp_row_size, and re-create the clustered index or run reorg rebuild, the new copy of the table may require more storage space.
The next time a page is affected by data modifications.
