SQL Server Index Formulas: Problems and Solutions

You're a SQL Server Developer, and you're ready to learn how to design and tune indexes. In this day long, example-packed seminar, Microsoft Certified Master Kendra Little will build your index design and tuning skills. 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

You'll get scripts for all the examples in this demo packed course, plus a set of online exercises to further increase your knowledge after the day is over.