Reclaiming Space After Column Data Type Change

  • David Fundakowski

    Ten Centuries

    Points: 1290

    Comments posted to this topic are about the item Reclaiming Space After Column Data Type Change

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    We do a weekly rebuild of our index set.

  • Bill Talada

    SSChampion

    Points: 11956

    Awesome article, thanks!

    For the free sql server version limited to 10 GB, Alter becomes a problem. I've gotten into the routine of always copying a table to an empty database, dropping the original table, and then creating the new and pulling in the data from the holding database. I've got scripts which automate the whole process. This keeps me from getting aborts due to the 10 GB limit.

    Actually I've always suspected "Alter" was smoke and mirrors due to the space usage and have avoided it from the start.

  • quackhandle1975

    SSChampion

    Points: 10963

    Great article, thanks.

    qh

    [font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]

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

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