Home Forums SQLServerCentral.com Articles Requested Reclaiming space after data type change RE: Reclaiming space after data type change

  • July 5, 2016 at 11:50 am

    #1888527

    david.fundakowski (7/5/2016)

    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.

    David Fundakowski

    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.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    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.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)