During the Comprehensive Database Performance Health Check, I often get the question about Estimated vs Actual Execution Plan. Let’s discuss.
Rollback TRUNCATE – Script – SQL in Sixty Seconds #105
One of the most popular questions, I keep on receiving is that – Is it possible to Rollback Truncate operation? The answer is YES.
Live Query Statistics in SSMS: SQL in Sixty Seconds #104
Live Query Statistics in SSMS draws a query plan that moves while the query runs, with a percentage beside each operator. This post tests a query with a wrong estimate on SQL Server 2025 and explains what the percentage means, why a Sort sits at zero, and how it differs from the cost percentage.
SQL SERVER – Offline, Detach and Drop – Differences – SQL in Sixty Seconds #103
if I can help them understand the difference between database status like Offline, Detach and Drop. It was very important to differences.
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,
Alter Index Add Column – Workaround – SQL in Sixty Seconds #097
However, while modifying it we faced a unique challenge that we can’t actually alter index to add columns. Let us discuss that today.
Column Statistics in SSMS: Update One With the Dialog
You can update column statistics in SSMS from the Properties window of a statistic, but a dialog gives no proof that anything happened. This post lists the steps, then uses T-SQL to prove the update with the modification counter and the sample size. It also shows why a full scan needs a statement of its own.