Section 2: Dos and Donts of T-SQL

This section serves as an introduction to query execution plans and how to leverage them for query troubleshooting, basic guidelines for writing efficient queries, and common T-SQL query patterns and anti-patterns.

The following chapters are included in this section:

• Chapter 4, Exploring Query Execution Plans
• Chapter 5, Writing Elegant T-SQL Query
• Chapter 6, Easily Identified T-SQL Anti-Patterns
• Chapter 7, Discovering T-SQL Anti-Patterns in Depth