How to Tune Indexes and Speed Up SQL Server

  • Instructor(s): Kendra Little
  • Length: 6.5 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 6+ 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

New! Advanced Missing Indexes. This is an additional half hour added in July 2014. See an advanced, tricky example of how to interpret missing index requests. First, you get a copy of dynamic management view information and you’re challenged to decide what indexes you would design. Then Kendra walks you through sample solutions. She’ll show you the surprising performance differences between different index choices in response to the missing index requests.

You can watch it for 18 months on your desktop, laptop, iPad, or iPhone. Buy it now for $299! 

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

Buy SQL Server Training Now

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

Kendra-130x170

About Kendra

Specialities: query tuning, index rocket science, SSDs

Off duty: drawings, dinosaurs, Spurious Capitalization

 

Suggested Courses

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.

css.php