I would like to do a write up on table size increase after changing column data types and how to reclaim the empty space.
Topics included would be:
Changing data types on columns
DBCC_Cleantable (depending on data type) or Clustered Index rebuild to get back space
DBCC IND/DBCC Page/%%Physloc%% to find DROPPED columns in the data pages
Please let me know what you think.