Why’s This Query So Slow in Prod? Check sp_BlitzPlanCompare.
You're testing a query, and you're just not getting the same performance between the development and production servers.
There's a huge list of common things that might be causing it:
Live online · Registration open through Nov 30
Our Black Friday Sale is on! Live Class Season Pass 2027: $995.
Four live class weeks of SQL Server performance tuning, with me answering questions as we go. Registration closes Nov 30; after that, it’s recordings only until next year.
- Fundamentals Week Nov 2–6, 2026
- Mastering Index Tuning 2027 Nov 30–Dec 4, 2026
- Mastering Query Tuning 2027 Jan 11–15, 2027
- Mastering Server Tuning 2027 Feb 8–12, 2027
11d 12h 45m Until the live classes start · Nov 2, 9 AM Pacific
$4,395
$995
Black Friday price
Live Class Season Pass 2027 · Save $3,400
3 posts a week, in your inbox
Plus a Monday roundup of my favorite database news from around the web.
Is your SQL Server okay?
Find out free with sp_Blitz and the First Responder Kit — trusted by DBAs everywhere.
Download the kitNeed hands-on help? SQL Critical Care® — my 2-day server assessment that finds the root cause and hands you the fix.
See consultingFresh from the blog
All posts
Performance Tuning
I’m Probably Not Supposed To Show You Microsoft’s Auto-Indexing Tool.
This needs to just stay between you and me, okay?
Microsoft's been working on automatically indexing SQL Server databases. No, not that Azure SQL DB feature, but one that actually works on-premises, going back through all supported versions of SQL Server. This is the brain child of Conor Cunningham and Jianjun Chen - yes, those guys, legends of the SQL Server engine, who've been hard at work on this for over two decades.
Thoughts on AI After My Panel Discussion
Today at Day of Data Orlando, I moderated a panel discussion with Bob Ward, Celia Brusatori, Kevin Feasel, Rob Volk, and Tim Radney talking about AI in your career, and whether it's your sidekick, hero, or villain.
A few really interesting things came up that I wanna share with you because I know a lot of y'all don't get out to meet your peers in person at regional or national conferences. I feel you. I try to bring you along with me.
[Video] Office Hours on the Last Alaskan Cruise of the Season
It's a cold, gloomy day on the very last Alaskan cruise of the season. Yes, I picked this on purpose! While I talk about why this is a fun cruise to be on, let's take your top-voted questions from https://pollgab.com/room/brento.
Prefer listening to this via podcast? Good news! You can now subscribe to Office Hours on Spotify, Apple Podcasts, Podcast Index, Podcast Addict, Podchaser, and anywhere else fine podcasts are found.
