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.
I can't speak for Steve Jones (the Editor of SSC) but, if fully demonstrable code and code to generate and fill a large table is included, I think it would be an awesome article.
is pronounced ree-bar and is a Modenism for R
First step towards the paradigm shift of writing Set Based code: Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair
When you put the right degree of spin on it, the number 318
is also a glyph that describes the nature of a DBAs job. Helpful Links:
How to post code problemsHow to post performance problemsForum FAQs