Text and image pages

Text and image pages can use large portions of memory and are commonly known as space wasters. They exist as long as a parent data row points to the text and image pages. These pages come into existence when a null update is done against the columns.

Find the current status for the table:

sp_help table_name

Use sp_chcattribure to deallocate text and image pages to open the space they occupy:

sp_chgattribute table_name, “deallocate_first_txtpg”,1

This switches the deallocation on. To switch the deallocation off enter:

sp_chgattribute table_name, “deallocate_first_txtpg”,0