Opinions expressed on this site are solely those of Kendra Little of Catalyze SQL, LLC. Content policy: Short excerpts of blog posts (3 sentences) may be republished, but longer excerpts and artwork cannot be shared without explicit permission.
on March 18, 2016
It’s just two weeks until I’ll be teaching index tuning in Huntington Beach, California.
This day long session is $99 – and it’s a great time of year to plan a quick visit to California, no?
In this day we’ll work entirely on problems and solutions.
You’ll get to think through different problems and step through the answers to see why some index designs are much better than others. You will learn:
- Why choosing the right key column order can make a huge difference in query performance
- How included columns can be used in more ways than you might expect
- Good and bad formulas for clustered indexes and guidelines to keep your table schema efficient
- When indexed views will make your queries faster and how to avoid pitfalls with them in both Standard and Enterprise Edition
- How to find and interpret index requests from SQL Server’s “missing index” feature
- How to identify which queries need indexes the most using the execution plan cache and SQL Server 2016 Query Store
- How to identify the paradigms where table partitioning shines
- What partition elimination is, why it’s critical to query performance, and how to tell if it’s happening in your queries
- Scenarios where Partitioned Views are the best fit
Seats are still available - reserve your seat now!