A client had slow overall performance because TempDB sat on a slow drive. In this SQL in Sixty Seconds video, I show how to move TempDB for performance.
Do MAX(col) Scan Table? – SQL in Sixty Seconds #106
While working on working on a Comprehensive Database Performance Health Check my client asked me – Do MAX(col) Scan Table? Let us learn about that today.
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.
Do MAX Function Scan Table? – Interview Question of the Week #289
Question: Do MAX Function Scan Table to retrieve the data?
Answer: Yes, if there are no indexes to help retrieve data. Let us learn it today.
Negative Identity Column – SQL in Sixty Seconds #101
I had a very interesting story to tell about a negative identity column from my recent Comprehensive Database Performance Health Check.
Keyword Join or Inner Join – SQL in Sixty Seconds #099
Have you ever wondered what is the difference between keyword Join or Inner Join? Are they same or different? If different, how are they different?