Of course yes, we can easily find a table in the execution plan with the Find Node feature of SSMS (SQL Server Management Studio).
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.