alter column dbcc cleantable

layout: post title: alter column dbcc cleantable

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.