SQL Server Query Tuning Best Practices - Part 3
SQL Server MVPs Aaron Bertrand and Kevin Kline continue their series on query tuning best practices. They go over some more patterns and anti-patterns including queries that are optimized for SELECT statements but not for DML statements, using functions in WHERE and JOIN clauses, and queries with wildcard searches.
Find more information about our products:
Plan Explorer: http://www.sqlsentry.com/plan-explorer