SQL Sentry's Aaron Bertrand (@AaronBertrand) digs into the left anti semi join, comparing NOT IN, NOT EXISTS, OUTER APPLY, EXCEPT, and OUTER JOIN methods.
