alter column dbcc cleantable

Jul 24, 07

if you have to perform an alter column on a large blob column, sometimes all your space doesn’t come back, you may want to issue a dbcc cleantable command on the table.

i meant to write a long post about this but i never did.