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.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
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.
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.
Are Not Equal to Operators Equal to Not In? – SQL in Sixty Seconds #102
What I love most about my job, is that I get to work with different people and answer questions. Are Not Equal to Operators Equal to Not In?
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.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.