SQL SERVER – Reclaim Space After Dropping Variable-Length Columns Using DBCC CLEANTABLE | Journey to SQL Authority with Pinal Dave

All DBA and Developers must have observed when any variable length column is dropped from table, it does not reduce the size of table. Table size stays the same till Indexes are reorganized or rebuild. There is also DBCC command DBCC CLEANTABLE, which can be used to reclaim any space previously occupied with variable length… Continue Reading...

Source: SQL SERVER – Reclaim Space After Dropping Variable-Length Columns Using DBCC CLEANTABLE | Journey to SQL Authority with Pinal Dave