Fundamentals of Index TuningYou’re comfortable writing T-SQL queries, and now you want to make ’em faster – without changing the queries themselves.

In this one-day course, you’ll learn:

  • How to design indexes for a query without looking at its execution plan
  • How to pick the order of keys in an index
  • How query parameter values can change which index is better
  • Where to find index recommendations using query plans, DMVs, and sp_BlitzIndex
  • How SQL Server’s index recommendations are built, and why they’re often wrong

Note: this course does not cover columnstore, In-Memory OLTP, XML, or spatial indexes. (Nothing against those – they’re just beyond fundamentals.)

Introductions

I introduce myself, the other attendees, and our goals for the class.

Menu
{"cart_token":"","hash":"","cart_data":""}