Post reply

Reclaiming space after data type change

  • July 5, 2016 at 8:21 am

    #323675

    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

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

  • July 26, 2016 at 1:12 pm

    #1892141

    This has been submitted.

  • July 27, 2016 at 2:25 pm

    #1892381

    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)

  • August 22, 2016 at 8:52 am

    #1896676

    Accepted

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

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