Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Update query - need suggestion RE: Update query - need suggestion

  • April 9, 2010 at 10:02 pm

    #1149474

    Baskar B.V (4/9/2010)

    Forgot to mention in the previous post.

    The total records which would get updated would be around 10 million records.

    My recommendation is that you split that up into batches of about 2 million rows or less. Every system has a "tipping point" depending on a whole bunch of unpredictable factors. Depending on where the tipping point of your system is, it may only take 6-12 seconds to update 2 million rows but may take 10 hours to update 10 million rows in a single query.

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