Home Forums SQL Server 7,2000 Strategies updating 1,000 records takes 5-6 minutes I would like to decrease the time that takes RE: updating 1,000 records takes 5-6 minutes I would like to decrease the time that takes

  • January 18, 2010 at 9:43 am

    #1105010

    Lynn Pettis (1/17/2010)

    Jeff Moden (1/17/2010)

    itsmeman (1/5/2010)

    This issue is done for now....

    Two way street here... please explain how this issue is "done for now".

    My guess, they ran the update that took 11 hours.

    Heh... that would be my guess, as well. 😀 Hopefully the OP will come back and confirm one way or the other but that isn't the general nature of such posts.

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