Should I use NOT IN, OUTER APPLY, LEFT OUTER JOIN, EXCEPT, or NOT EXISTS?
I dig into the left anti semi join, comparing NOT IN, NOT EXISTS, OUTER APPLY, EXCEPT, and OUTER JOIN methods.
Monthly Archive: December 2012
December 2012 Cumulative Updates are available for SQL Server 2008 R2
Microsoft released new cumulative updates for SQL Server. SQL Server 2008 R2 Service Pack 1 Cumulative Update # 10 KB Article: KB #2783135 16 fixes are listed at the time of publication Build number...
Cumulative Update #5 is available for SQL Server 2012 RTM
Microsoft has released Cumulative Update #5 for SQL Server 2012 RTM. Note this is *not* a cumulative update for Service Pack 1. So if your build # is >= 11.0.3000, you should not be...
SQL Server 2012 Service Pack 1 & Cumulative Update 1
Some important informations on updates for SQL Server 2012.