Just about every database professional on Earth has the same goal: Make things faster.
There are numerous ways to achieve that goal, but for many people it comes down to a series of hunches, guesses, and trying whatever seemed to work last time.
What if there was a more efficient way to get the job done? What if you could understand what's going on under the covers, know your options, and make the right moves for your actual situation?
That's what my full-day Tuning Your Biggest Queries seminar is all about. In this unique class you'll learn about how the query processor works, how the query optimizer thinks, and how you can leverage an understanding of these internals to make your queries faster. What really sets this content apart is that there is almost no focus on indexing -- only a very brief discussion at the end of the day, and only after you've already learned how to improve query performance by orders of magnitude through rewrites.
The idea is not to make you an index champion. The idea is to set you on the path to advanced query tuning mastery.
I am pleased to announce the final 2016 public delivery of the seminar -- Friday, December 2, in Washington DC. And you can get early bird pricing through the end of this week!
This delivery will act as a pre-conference seminar for SQL Saturday DC, but you are free to attend either or both.
An updated course outline follows. Looking forward to seeing you there!
Tuning Your Biggest Queries - December 2 - Washington DC
Module 1: Query Plans
- How Query Plans Really Work
- Data Acquisition Iterators
- Join Iterators
- Aggregation and Analysis Iterators
- Parallel Processing
Module 2: Plan Shaping
- T-SQL Rewrites That Waste Your Time
- T-SQL Rewrites That Work
- Query Hints
- Leveraging Row Goals For Plan Control
- Understanding Ideal Plan Shape
- Performance Debugging Complex Plans
Module 3: Index Optimization
- The Levels of Index Understanding
- How B*Tree Indexes Really Work
- How to Design Optimal B*Tree Indexes
- How to Choose Among Indexing Options
- Columnstores vs. B*Trees