Of course yes, we can easily find a table in the execution plan with the Find Node feature of SSMS (SQL Server Management Studio).
Count Table in Cache – SQL in Sixty Seconds #149
Earlier I wrote how to find the count of tables used in queries from cache. Here is the Count Table in Cache video in SQL in Sixty Seconds.
SQL SERVER – Find Count of Table Used in Query From Cache
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.
SQL SERVER – Disable Rowgoal Optimizer
In my career, this is I think 2 or 3 rd time I have seen this one, so do not consider this as a generic solution. How to Disable Rowgoal Optimizer works?
SQL SERVER – Number of Rows Read – Execution Plan
Recently one of the clients sent me images from the execution plan and his question was about the Number of Rows Read in the SQL Server Execution plan.
Slow Running Query – SQL in Sixty Seconds #146
One of the most popular questions I receive during Comprehensive Database Performance Health Check is if I have a script that lists Slow Running Query.
SQL SERVER – Long Running Queries with Execution Plan
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.