Reclaiming space after data type change

  • 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

  • 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)

  • This has been submitted.

  • Can't wait to see it. Thanks, David.

    --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)

  • Accepted

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply