It is possible to zoom in SSMS (SQL Server Management Studio). A client asked me during a Health Check, so here is how to do it.
Find a Table in Execution Plan – SQL in Sixty Seconds #151
Finding a table in a huge execution plan is a nightmare. In this SQL in Sixty Seconds video, I show how to find any table in execution plan with SSMS.
Transactions and Variables – SQL in Sixty Seconds #150
Transactions and Variables both are not related at all. There is no impact of a transaction on a variable. Let us learn about it today.
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.
List All Sessions – SQL in Sixty Seconds #148
One of the most frequent questions which I receive from my client is about activity going inside SQL Server and how to list all sessions.
Line Numbers for SSMS Efficiency – SQL in Sixty Seconds #147
This is when the line numbers in SSMS comes in extremely handy and let us learn in today’s blog post how we can do that. Let us learn today.
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.