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
