Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Inserting rows a row at a time instead of in batches- RBAR is faster??? RE: Inserting rows a row at a time instead of in batches- RBAR is faster???

  • December 5, 2015 at 8:14 pm

    #1844226

    MadAdmin (12/5/2015)

    Proof is in the pudding always. Try the set based and measure. Then try the rbar and measure. Especially when the advice sounds odd.

    Make the person that made the claim prove it. Saves time on your part and gives you a chance to see what they think is good code. That way you're also testing the person and not just the method.

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