Monthly Archives: December 2010

SQL not in or left join

There is an interesting article here: http://blog.sqlauthority.com/2008/04/22/sql-server-better-performance-left-join-or-not-in/ It’s interesting to note that when I tried to recreate this in the real world, the not-in was not returning anything.  This can happen if the sub-query can return nulls.  So, if the … Continue reading

Posted in Uncategorized | Leave a comment