Home Forums SQL Server 2014 Development - SQL Server 2014 how to write query RE: how to write query

  • September 12, 2013 at 6:01 am

    #1649658

    dwain.c (9/11/2013)

    BTW. I really like this.

    Jeff Moden (8/31/2013)

    That's why I teach my Developers to learn the more performant methods... so they can do it in their sleep and won't have to rewrite code to fix performance problems that should have been avoided to begin with.

    You can lead a horse to water but how the heck do you get the beast to drink?

    It takes a lot of patience but the answer is, hire only those horses that are willing to drink and make the water taste good. 😉

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