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

 

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.