In this full-day seminar, you will gain core knowledge about how SQL Server works, along with a host of information covering memory usage, the optimizer, indexes, statistics, and table design.

Most importantly, you will be exposed to an elaborate and detailed tour of T-SQL patterns and anti-patterns, many of which will enlighten or surprise you. You will also learn about default settings to override, trace flags that can help query analysis, optimizing tempdb, and how to avoid “it worked on my machine” syndrome.

Packed with sample code, live demos, and even pop quizzes, you will leave the room armed with many new insights into making your design phase more robust, your queries more efficient, and making life easier for your DBAs, fellow developers, and end users.
Presented by Aaron Bertrand at SQLBits XVI