Want to keep yourself up to date with the latest news from Brent Ozar Unlimited®?
Subscribe using the "Follow" button below and we provide you with customized updates, via topic or tag, that get delivered to your email address, your smartphone or on your dedicated news page on follow.it.
You can unsubscribe at any time painlessly.
Title of Brent Ozar Unlimited®: "Brent Ozar Unlimited - SQL Server Consulting and Training"
Is this your feed? Claim it!
Need to share an execution plan, like on forums or on Stack Overflow, and you wanna get their advice as quickly as possible? Paste the XML into PasteThePlan.com and you get a link that you can share to anyone with your plan’s details.
The user interface is now cleaner, with separate tabs ...
Good news! My training day workshop, Dev/Prod Demon Hunters, was sold out, but Bits just moved me into the auditorium with way more capacity and space for you to stretch out.
Plus, there’s po...
Let’s go through a LOT of your top-voted questions from https://pollgab.com/room/brento on a VERY early Saturday morning.
00:00 StartLet’s have some fun.
Put yourself in the frame of mind of the fella who writes this blog.
What do you think I send to ChatGPT?
In the comments, write prompts that you think I’m sending to the giant robot...
The short answer: in the real world, only the first column works. When SQL Server needs data about the second column, it builds its own stats on that column instead (assuming they don’t already exist), and uses those two statistics together – but they’re not really correlated.
For the longer answer, let’s take a large version of