I dropped a char(10) column from a table that has about 111 million rows (30gb data, 11gb index)
I then ran an index rebuild on the clustered index. This ate up all the space on the drive containing the database.
I then ran
dbcc cleantable and got all the space back, plus a few more gigs.
Is there a way to reclaim space from the dropped column when there isn't enough space for index rebuild?
Or did the
cleantable operation actually reclaim the space? (I know it reclaimed space, but I'm guessing it's possible it reclaimed space for a different reason, since cleantable isn't suggested as the way to reclaim space after dropping a column)