Joins vs. Exists vs. IN: Not all filters are created the same.
Not all filter commands are created equal. Different filtering operations should be used at different times to get the best performance our of your SQL Server.
New Article: SQL Server tempdb best practices increase performance
I’ve recently published a new tip on SearchSQLServer.com called “SQL Server tempdb best practices increase performance“. Denny