Home Forums SQL Server 2005 T-SQL (SS2K5) Performance issue with tally solution RE: Performance issue with tally solution

  • April 12, 2009 at 11:21 pm

    #976392

    Florian Reischl (4/12/2009)

    Hello everybody!

    I have a performance issue with a set based solution. Please could you advice me what I'm doing wrong?

    ORDER BY on unindexed Tally table, for starters. All the other comments about large table variables may apply, as well, although I haven't tested the code, yet.

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