Posts by Brent Ozar

[Video] Office Hours: Speed Round Edition

Videos
0
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…
Read More

[Video] Office Hours: Long Answers Edition

Videos
0
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…
Read More

Office Hours: Dodging Work Edition

Videos
8 Comments
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?…
Read More

[Video] Office Hours in the Valley of Fire State Park

Videos
0
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 ,…
Read More
Eyes up here, kid

Here’s What I’m Teaching at the 2022 PASS Summit.

#SQLPass
2 Comments
The lineup for the PASS Data Community Summit is out, and in addition to my pre-conference workshop on Mastering Parameter Sniffing, I’m also teaching two sessions: Everything You Know About Parallelism Is Wrong. Just because you see parallelism icons on execution plans doesn’t mean the query went parallel. SQL Server doesn’t load-balance work across CPU cores.…
Read More
Office Hours - ask me anything.

[Video] Office Hours Speed Round

Videos
0
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…
Read More