Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jeff Moden Hidden RBAR: Counting with Recursive CTE's RE: Hidden RBAR: Counting with Recursive CTE's

  • August 8, 2011 at 12:35 pm

    #1365459

    CELKO (8/8/2011)

    This was really good. I was surprised that the WHILE loop did so better than the rCTE. I was expecting the loop to be a bit better because it does not have to touch a table except to write an integer, but I expected the optimizer to turn the rCTE into a loop.

    Thanks for stopping by and for the feedback, Joe. I think I'm regretting not including a While Loop in the coded demonstration in the article. Maybe I'll go back and add it in along with the results in the graphs, as well. I've just got to find the time to do that.

    Shifiting gears, how's the 2nd edition of "Trees" coming along?

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