Use sp_chgattribute to add or change the expected row size for a table. For example, to set the expected row size to 190 for the new_titles table, enter:
sp_chgattribute new_titles, "exp_row_size", 190
To switch the row size for a table from a current, explicit valut to the default exp_row_size percent, 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 you create a clustered index on the table or run reorg rebuild. The expected row size is applied as rows are copied to new data pages.
If you increase exp_row_size, and recreate 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.
