Posts by Brent Ozar

Not all of the questions you post at https://pollgab.com/room/brento require long answers. Here’s a quick speed round: Here’s what we discussed: 00:00 Introductions 00:24 EngineHorror: Hey Brent! What’s your opinion on page- and row-level compression in general? Is it true it increases locking besides burning extra CPU? 01:08 Pony: Is Microsoft Assessment and Planning tool…

This time on Office Hours, I let a few questions piled up at https://pollgab.com/room/brento that required in-depth answers to really do ’em justice. In particular, there was a statistics question that needed demos. Here’s what we covered: 00:00 Introductions 00:35 Grogu: Did DBA Brent ever have to support a version of SQL Server that Microsoft…

Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. Today, I’m dodging work, so I went through your questions while I waited for the coffee shop to open: Here’s what we covered: 00:00 Introductions 03:28 Ivan: What are the top signs that a table has a poor clustered index?…

I drove the Ferrari out through the Valley of Fire State Park and stopped out in the middle of nowhere to take the questions you’d upvoted at https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:39 Saket Mittal: Hi Brent, I am working with a developer on a query, this query has lots of join ,…

In ten minutes, let’s cover as many questions as possible from https://pollgab.com/room/brento: Here’s what we raced through: 00:00 Introductions 00:17 dbacat: We’ve been fighting an AG issue for a while. Sometimes during failover, one or a few databases go into initializing/recovery state on the new secondary. It’s random, never consistent. Only fix is to drop…