To watch a running query, open Activity Monitor in SSMS 22, find the query in Active Expensive Queries, and open its live execution plan. It also shows the settings that older versions need and a T-SQL query that reads the same facts.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
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.
What Happens If the Clustered Index is Disabled? – Interview Question of the Week #291
Question: What Happens If the Clustered Index is Disabled?
Answer: If you disable the clustered index, you can’t retrieve data from the table.
Giving Your First SQL Server Talk at a User Group
Prepare your first SQL Server talk with one real problem, two resettable demos, a timed thirty-minute outline, a rehearsal, and a backup plan.
Who Dropped Your Table? – SQL in Sixty Seconds #112
Who Dropped My Table? – I was recently asked this question in Comprehensive Database Performance Health Check. Let us learn about it today.
Single Column Single Row and TABLE SCAN – SQL in Sixty Seconds #111
Can a single column and single row result do an entire table scan? I recently got this question in my Comprehensive Database Performance Health Check.
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.