One Query Many Plans – SQL in Sixty Seconds #171

One Query Many Plans - SQL in Sixty Seconds #171 171-OneQueryManyPlans-yt-800x450 Yesterday I wrote a blog post SQL SERVER – Same Result Same Query Plan – Different Entry in Cache, where I had discussed my experience from Comprehensive Database Performance Health Check. After the blog post, lots of people asked me it will be more helpful if I can create a video on the same topic of one query many plans.

As per the request here is the video based on the blog post of One Query Many Plans. Here is the blog post where you can download the query to inspect your cache memory: SQL SERVER – List Query Plan, Cache Size, Text and Execution Count.

Well, that’s it for today. If you liked this video, please do not forget to subscribe to my YouTube Channel – SQL in Sixty Seconds.

Here are my few recent videos and I would like to know what is your feedback about them.

Reference: Pinal Dave (

Execution Plan, SQL Cache, SQL in Sixty Seconds, SQL Performance, SQL Server
Previous Post
Best Value for Maximum Worker Threads – SQL in Sixty Seconds #170
Next Post
Avoid Join Hints – SQL in Sixty Seconds #172

Related Posts

Leave a Reply