Honestly, it has happened to me quite many times and it is indeed frustrating. Today we will learn about how we can recover crashed queries in SSMS.
Email an Execution Plan – SQL in Sixty Seconds #114
Today we are going to learn how we can send Email an Execution Plan. In the video, I explain how one can send query plans via an email.
Execution Plan – Estimated vs Actual – SQL in Sixty Seconds #113
During the Comprehensive Database Performance Health Check, I often get the question about Estimated vs Actual Execution Plan. Let’s discuss.
SQL SERVER – Live Query Statistics – SQL in Sixty Seconds #104
The biggest challenge is to know about the queries current execution status. In this video, we are going to see the details about Live Query Statistics.
How to Get Rowcount of Every Table in SSMS? – Interview Question of the Week #288
Question: How to Get Rowcount of Every Table in SSMS?
Answer: After watching my earlier video on the fastest way to get the rowcount for the table,
SQL SERVER Management Studio – Update Column Statistics Via SSMS
Today we will see how we can update Column Statistics via SSMS (SQL Server Management Studio). This feature was broken earlier and now fixed in SSMS 18.6.
How to Generate Script for SQL Server 2005 from SQL Server 2019? – Interview Question of the Week #285
Question: How to Generate Script for SQL Server 2005 from SQL Server 2019?
Answer: Actually, I got this question from my client.