My client sent me an interesting scenario where a query with adaptive join was performing badly. Let us learn how to disable adaptive joins.
While all other methods work fine, let us see how easily we can find this in an SSMS. Let us learn how to find a table in an execution plan.
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.