Query Tuning with Hints & Optimizer Hotfixes

Rated 5.00 out of 5 based on 4 customer ratings
(4 customer reviews)

$99.00 for 2 years

Get fast, consistent performance in your queries in SQL Server by using hints and trace flags to explore and change your execution plans.

Out of stock


Sometimes bad execution plans happen to good queries

In this course you’ll learn the pros and cons of using hints, trace flags, and scoped database configuration to tune your queries in SQL Server.

This course gives you two hours of query tuning fun in online videos, with plenty of quiz questions along the way and sample interview questions at the end.

Demos are run against SQL Server 2016 in the videos, but most of the hints and settings shown in this course can be used against lower versions of SQL Server as well.

Each lesson is 15 minutes or less to make it easy for you to fit learning into your busy day.

Here’s what’s covered in the course

Why do we need hints and optimizer hotfixes? (3 minutes)

Query tuning with hints (73 minutes):  Six lessons which use hints to tune a slow query. Topics include: hinting cardinality estimation, setting row goals, join hints, temp tables, table variables (and a related trace flag), query re-writes inspired by hints, and frequently used hints.

Recompile hints aren’t created equal (22 minutes): Three lessons that explain what ‘recompile’ means, a super simple load test of different types of recompile hints, understanding the impact of recompile on the plan cache, and recompile bugs and best practices.

How to “take out” an execution plan (8 minutes): One lesson on the variety of ways you can bump an execution plan (or a lot of plans) out of cache.

Query optimizer hotfixes (22 minutes): Three lessons explaining and demonstrating trace flag 4199 and hints and database scope options to enable query optimizer hotfixes.

Interview questions and answers (7 minutes)

Not sure if it’s right for you?

Browse the course modules and preview the first two videos in the course.


4 reviews for Query Tuning with Hints & Optimizer Hotfixes

  1. Rated 5 out of 5

    Nizami Khalilbayli (verified owner)

    As always, Kendra`s explanation is very informative and easy to understand. Learned so much things regarding query optimization. Will wait for new courses from you, Kendra!

  2. Rated 5 out of 5

    anjanwahwar (verified owner)

    I came across Kendra’ learning video series while surfing web to find possible solution to my bad performing query and I must say your video unlocked a lot of answer to me.

    The way she explained the process was excellent and the course content was also great. Thanks for all the effort put in. I will love to see more video on interpreting SQL Server query execution plan to find possible solution to bad performing query.

  3. Rated 5 out of 5

    Bill.Mentzer (verified owner)

    The scripting examples are a huge help. Multiple modes of review get that information ingrained. The presentation style is direct but welcoming. I’ve learned so much!

    Makes a great holiday gift to the DBA in your family.

  4. Rated 5 out of 5

    paul.kemner (verified owner)

    Another excellent course. Kendra explains pros and cons of different approaches, and what factors to weigh when choosing them. A clear and engaging presentation.

Add a review

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

You may also like…