Change Character

  • Nita Reddy

    Hall of Fame

    Points: 3976

    I need to change Varchar column from 100 to 200 for one of the table

    Table has 80 Million records and allows Null values.

    I don't have test server to test, so i am curious how long it will take to Alter Column from 100 to 200 Varchar

  • Jeff Moden

    SSC Guru

    Points: 995144

    Although I suspect it will actually be fairly rapid, there's no way to guesstimate such a thing.  Create a smaller test of a couple million rows and measure.  You should also measure what it may do to your log file.


    --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.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

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

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

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