Adding or changing an expected row size

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: