Earlier I wrote a blog post on Forwarded Records and Performance and lots of people liked the blog post. Here is you can read the blog post SQL SERVER – What is Forwarded Records and How to Fix Them?
Hide Code in SSMS – SQL in Sixty Seconds #154
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.
150 Videos on SQL in Sixty Seconds
I am so happy to share with you that the other day when I posted Transactions and Variables – SQL in Sixty Seconds #150, I completed 150 videos.
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.