How to Tune Indexes and Speed Up SQL Server

  • Instructor(s): Kendra Little
  • Length: 7 hours
  • Cost: $299

You want to become an expert at index tuning, but you can’t find a good start-to-finish training course. Kendra Little teaches you the basics, the gotchas, and the tricks of SQL Server indexing in 7 hours of training. You’ll get TSQL scripts to dive into index tuning examples as you watch the videos.

You’ll use interactive quizzes to test your knowledge as you learn:

  • How to create, analyze, and understand clustered and nonclustered indexes
  • When to use index includes, filtered indexes, and other special structures to speed up your queries.
  • How to use free tools to find hidden columns in your indexes
  • How to tune a workload using the SQL Server Dynamic Management Views
  • How to avoid common indexing anti-patterns that drag down your database server
  • How to find critical index changes in the Execution Plan Cache
  • How you can use data to prove that your changes improved performance
  • Advanced missing indexes: take a tricky indexing challenge

The SQL Server index types/related concepts covered in this training are:

  • Clustered indexes
  • Nonclustered indexes
  • Included columns in Nonclustered Indexes
  • Primary Keys
  • Heaps
  • Filtered Indexes
  • Indexed Computed Columns
  • Missing Index Requests

Downloadable demo scripts are compatible with the SQL Server 2012 AdventureWorks database and can be used on your own copy of SQL Server 2012.

Buy it now for $299.Get 18 months streaming access.

About Kendra

Specialities: query tuning, index rocket science, SSDs

Off duty: drawings, dinosaurs, Spurious Capitalization


Suggested Courses

How to Read SQL Server Execution Plans

  • Length: 5.5 hours
  • Cost: $299
You’re comfortable writing queries, but some of them are slow – and you need more ways to tune than just adding indexes. You’ve heard that you should read execution plans, but you don’t know where to start.

Buy it now and get started

Developer's Guide to SQL Server Performance

  • Length: 7 hours
  • Cost: $299
You’re a developer or DBA stuck with a database server that's not going fast enough. You've got a hunch that the biggest bottleneck is inside the database server somewhere, but where? In 6.5 hours of online training, you'll learn:
  • How to use powerful scripts to identify which queries are killing your server
  • What parts of the database server are holding you back
  • How to tackle indexing improvements
  • How to identify query anti-patterns.

Buy it now and get started

The Fine Print: Read our “Refund and Cancellation Policy for Training Videos” here. Want to pay by check or purchase order? Download our order form spreadsheet, pick out what you want, hand it to your company's accountants, and we'll set you up when we get your check.