Query Tuning Internals for the Advanced SQL Developer - Kevin Kline

For September, we've got special guest speaker Kevin Kline! Note the non-standard date for this meeting -- second Tuesday instead of first Wednesday of the month!

Query Tuning Internals for the Advanced SQL Developer - Kevin Kline

Learn the hidden internals of query processing and apply those lessons in your SQL applications, diving deep into the algebrizer and optimizer.

Skilled SQL developers know that the SQL Server query optimizer uses a multi-step process to produce execution plans. But what about deeper components like the parser, the binder, the algebrizer, as well as the optimizer itself? This session will teach you advanced techniques for query tuning as well as surprising behaviors of the query optimization process that can have a dramatic impact on performance, with special attention paid to the processes controlled by the algebrizer, including associative, commutative, and transitive transformations. We will examine a variety of everyday queries whose performance can be greatly improved by apply a deeper understanding of these internal behaviors. Lots of examples and demos!

•Goal 1: Learn advanced and undocumented methods to see the steps of parsing, binding, algebrizing, and query optimization.

•Goal 2: Explore the SQL Server internal memo structure to see how SQL Server uses the heuristics of the algebrizer and query optimizer.

•Goal 3: Walk through several examples of SQL queries whose behavior can be greatly improved when you apply what you’ve learned about the algebrizer and query optimizer.

Experience in writing and tuning SQL queries, as well as reading execution plans, will be beneficial to attendees of this 300-400 level session.

Kevin Kline is a database expert and Principal Program Manager at SentryOne. A Microsoft SQL Server MVP since 2003, he is a founder and former president of PASS. Kevin is an author of many books, blogger, columnist, and popular international speaker. Kevin’s best known book is the best-selling "SQL in a Nutshell". He contributes monthly to Database Trends & Applications magazine. He tweets at @kekline (https://twitter.com/kekline) and blogs at https://blogs.sentryone.com/author/KevinKline/.

Sponsors:
TEKsystems
http://www.teksystems.com
SentryOne
http://www.sentryone.com

Sacramento SQL Server User Group
https://www.meetup.com/Sacramento-SQL-Server-User-Group
http://sac.pass.org
https://twitter.com/sacsqlug
https://www.linkedin.com/groups/2825448

Meeting location:

2700 Gateway Oaks Drive is located in the Sutter Health business park at the northeast corner of the intersection of Gateway Oaks Drive and West El Camino in Sacramento. The 2700 building is at the back of the complex; you can see I-5 from the parking lot. Enter the building from the parking lot side, not the courtyard side. Once inside the building, take the stairs or elevator to the second floor, then enter Suite 2600. In the reception area, check the monitor to find our room for the evening and then proceed to that room.