I have received so many emails from all of you to create a video on the topic of SQL SERVER – Hide Code in SSMS. Here is the video on the topic.
Zoom in SSMS – SQL in Sixty Seconds #153
It is possible to zoom in the SSMS (SQL Server Management Studio). I was recently asked by my client if this is even possible during Health Check.
Transfer Schema of Table – SQL in Sixty Seconds #152
My client during the Comprehensive Database Performance Health Check. I created a video on the topic of Transfer Schema of Table.
Find a Table in Execution Plan – SQL in Sixty Seconds #151
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.
Count Table in Cache – SQL in Sixty Seconds #149
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.
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.