Home Forums SQL Server 2005 SQL Server Newbies column to calculate the balance stock dynamically RE: column to calculate the balance stock dynamically

  • March 3, 2009 at 9:20 pm

    #952850

    beezell (3/3/2009)

    Hmmm... there are very few scenarios where I've seen cursors faster than CTE or non-RBAR (row by agonizing row) methods. Just curious how many rows you're running through?

    Cheers,

    Brian

    That's because what looked like set based code is actually RBAR on steroids known as a "Triangular Join" and it will cripple a server on very low rowcounts even as low as 20,000 rows. Read all about in the following link...

    http://www.sqlservercentral.com/articles/T-SQL/61539/

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