Earlier I had written a blog post about SQL SERVER – Find Count of Table Used in Query From Cache. Today we will see a video for the same.
we had an interesting situation where we wanted to Find the Count of Table Used in Query From Cache. Let us see how we can do that in today’s blog post.
I have a simple script that will list all the long running queries in the database with the execution plan. Well, the answer is yes.
The question is about JOIN Elimination for Not Selected Column. It was discussed in the Comprehensive Database Performance Health Check.