• dphillips (9/16/2008)


    Jeff, great examples and test building. It amazes me you have the time to post such significant and applicable content and in such detail.

    Thank you for your many contributions!

    Thank you very much. Heh... I stay up way too late on some of these.

    The real key is that I have a good friend that I argue with/agree with once in a while. He said something I'll never forget... "A developer must not guess. A developer must know!" On lot's of these posts I say, "Darned good question... I know what some of the myths are, what's the truth?" I write a bunch of code (lots of copy and paste in cases like this) and test the heck out of it so I know the answer for sure before I post... settles lots of arguments when you have the proof in the form of code. 🙂

    As you can see, though, certain machines behave differently. Remi had a machine that made LIKE look much worse than it does on my machine. So, I also post my results so people can compare. If I'm lucky, someone else (couple of good folks helped in this thread) will run the same code and post their results and we all learn more than what the original question was. Give some, take some, everybody (including me) learns more than expected. 😀

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