Month: April 2020

Query Store, force my plan on that other server too, please?

This blog is a follow-up to a discussion I recently had on Twitter, started by Patrick Joliffe asking some people: if you need to force an execution plan, would you prefer to do it through Query Store or through a Plan Guide? Most people agreed that Query Store should be preferred. Not only because it is easier to use, but also (perhaps I should say mainly) because it provides better insight and visibility. The last thing you want to do is to lose track of what queries you have forced an execution plan for. After all, you really need to…

SSMS 18.5 – small change, huge effect!

The latest version of SSMS has just been released. Version 18.5. And I need all of you to update your version. Now. Yes, right now. Here’s a link to download it. I’ll wait. Why the rush, you ask? Because hidden in between all the little (and some big) improvements and fixes, there is one true gem. One I wish Microsoft had done … oh, let’s say two decades ago? Misleading information If you have been to any of my talks about execution plan, you probably have heard me fuming about (and warning you for) the way estimated and actual number…

Announcing … the execution plan video training

In the past years, several people have suggested that I should make videos to help people get a better understand of execution plans. I’ve always shied away from the idea. Creating video content, or rather, creating top notch quality video content, takes a lot of time. Would it not make more sense to create more content for other channels? On the other hand, a lot of people learn more from live training, or from video training (the closest alternative), than from reading blogs or articles. And my goal is to educate as many people as possible. It’s impossible for me…

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.