Did you know that Microsoft SQL Server doesn't automatically reuse space from variable length columns that have been dropped from a table? This blog shows you how to reclaim that space using the DBCC CLEANTABLE command.
read more | digg story
a0000.blogspot.com