Question: If a have a table with many rows of data in it, then drop a column. Then I do various data updates in the middle of the table that would cause SQL Server to rewrite the pages in the middle (e.g., ordinary updates or inserts).
Would those rewritten pages have the now-dropped column's space reclaimed automatically as the pages get rewritten?