Restructure 100 Million Row (or more) Tables in Seconds. SRSLY!

  • Jeff Moden

    SSC Guru

    Points: 994284

    Gosh... another great article, Solomon. As with anything else, planning and having the resources available for parallel table existance is important but this article covers a problem that a whole lot of people have had even on just SSC. Instead of explaining the whole gambit in the future, I'm just going to point them to this article if they have the extra disk space. Very well done.

    As a side bar, I agree with you about triggers in general but especially on the type of triggers needed to pull off this bit SQL prestidigitation. If they are well written and supported by correct indexing, they don't add much in the line of overhead at all.

    Again, my hat's off to you for this great 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.
    "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)

  • Cliff Jones

    SSChampion

    Points: 10517

    Solomon Rutzky (10/5/2012)


    now[/i] in SQL Server 2012 you can add a NOT NULL field with a default without locking the table ...

    That is a nice little tidbit of information that I had missed in the SQL 2012 documentation. Thanks for pointing that out, that will be helpful.

  • Luke C

    Right there with Babe

    Points: 790

    Solomon, here's the article I wrote that similar but instead uses change tracking. [/url]

    Luke C
    MCSE: Data Platform, MCP, MCTS, MCITP - Database Administrator & Database Developer

  • Neha05

    Default port

    Points: 1494

    Great article.

Viewing 4 posts - 31 through 34 (of 34 total)

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