Posts by Brent Ozar

Office Hours Podcast

Announcing Saturday & Sunday Office Hours.

During the quarantines, I’m doing free training. It looks like we’re going to be stuck inside here for another long while, so for the next couple of months, I’m bringing back Office Hours, but on a different schedule. Every Saturday & Sunday morning from 6AM-8AM Pacific (iCal), you can catch me on my Twitch, YouTube, or Facebook…
Read More

Want Your Own Private Conference?

Your team has been reading my blog, watching my free public streams, and using the First Responder Kit scripts for years. They’ve gone as far as they can go on their own, learning from Google, and now they’re ready for the next level. I can bring the conference to you – except way better than a…
Read More

The 201 Buckets Problem, Part 1: Why You Still Don’t Get Accurate Estimates

I’ll start with the smallest Stack Overflow 2010 database and set up an index on Location: Transact-SQL USE StackOverflow2010 GO CREATE INDEX Location ON dbo.Users(Location); GO SELECT COUNT(*) FROM dbo.Users; GO 123456 USE StackOverflow2010GOCREATE INDEX Location ON dbo.Users(Location);GOSELECT COUNT(*) FROM dbo.Users;GO There are about 300,000 Users – not a lot, but enough that it will…
Read More