• ChrisM@Work (7/17/2013)


    Really? What type of join is shown for Query 1 and Query 2?

    NOT IN and NOT EXISTS do perform identically with identical execution plans if the columns are defined as NOT NULL.

    http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass