SQL Server MVPs Aaron Bertrand and Kevin Kline continue talking about query tuning best practices. In this video, they continue to discuss more patterns and anti-patterns. Aaron starts out by going over why you should always specify the schema. Other topics that are covered include SP_prefix and queries with IN (…) / OR. Then, Kevin goes over two less commonly known things to SQL and T-SQL programmers, which are situations where your code can cause unwanted recompiles and the transitive property of indexes.
Click here to find out the winners of the Richard Petty Driving Experience: sqlsentry.tv/who-is-the-worlds-fastest-dba/
Note: eBook no longer available via Amazon. Email firstname.lastname@example.org if you are still interested in receiving a copy.