Home Forums Article Discussions Article Discussions by Author Discuss content posted by Stephen Tirone Caution with EXCEPT RE: Caution with EXCEPT

  • January 18, 2010 at 9:53 am

    #1105017

    jdurandt (1/18/2010)

    That's interesting

    I benchmarked EXCEPT vs WHERE NOT IN (SELECT .....), and for my dataset, server, DB version etc. the performance results were equivalent, or biased towards EXCEPT.

    Can you give more details about your scenario?

    Can you post your benchmark code, please?

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