David Moutray (6/24/2013)
I will be particularly interested to play around with using NOT EXISTS logic where we currently use WHERE IS NOT NULL.
If you feel like reading up on it a bit before diving in, these two articles are my favourites:
http://www.sqlperformance.com/2012/12/t-sql-queries/left-anti-semi-join
http://explainextended.com/2009/09/15/not-in-vs-not-exists-vs-left-join-is-null-sql-server/
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi