[Video] Office Hours: Palm Springs, California Edition
On a road trip from San Diego to Vegas, I stopped in Palm Springs and answered your highly-upvoted questions from https://pollgab.com/room/brento.
https://youtu.be/1P_1DFXy-h0
Indexing and Statistics
Designing, evaluating, maintaining, and troubleshooting indexes and statistics.
568 associated posts270 primary posts
Production DBA
Office Hours Speed Round, Text Edition
Not all of the questions y'all post at https://pollgab.com/room/brento are hard - some of 'em can be answered in just a line or two:
Q: Hany: Hello Brent, Who's "Brent Ozar" in the Azure world?
[Video] Office Hours: Vail Fireside Chat
You posted and upvoted questions at https://pollgab.com/room/brento, and I sat down by the fire on a chilly evening in Vail, Colorado to answer 'em. I was driving cross-country, heading back from a road trip to see my mom.
https://www.youtube.com/watch?v=SvLQdyTreQ8
[Video] Office Hours in Moab, Utah
On a cross-country trip, I stopped in Moab, Utah and answered your top-voted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=TbrGmJGOL_o
[Video] Office Hours: Cabo Balcony Edition
Post your questions at https://pollgab.com/room/brento and upvote the questions you'd like to see me discuss.
The light balance on this video is all over the place, getting brighter and darker constantly, so you might wanna leave this one playing in the background and just listen to it rather than watch.
[Video] Office Hours: Cabo Pool Edition
You posted SQL Server questions and upvoted the ones you'd like to see at https://pollgab.com/room/brento, and before the Cabo Clasico finals start for the day, I sat by the pool to talk through 'em:
https://www.youtube.com/watch?v=--nU3K47Eyc
Performance Tuning
“Index Seek” Doesn’t Mean Much.
When you see "index seek" on an execution plan, that doesn't mean SQL Server is jumping to exactly the row you're looking for. It only means that SQL Server is seeking on the first column of the index.
This is especially misleading on indexes where the first column isn't very selective.
Production DBA
Office Hours, Text Edition: No-Brainer Questions
For my Office Hours streams on my Twitch channel, y'all post questions at PollGab and upvote the ones you'd like to see me discuss on the stream. However, not all questions require a video answer. Here are some simple no-brainer ones:
Q: BehindTheScenesDBA: With all its limitations, what do you think about memory-optimized tables? Have you recommended to a client to use it?
[Video] Office Hours: New Las Vegas Home Office Edition
It's the first webcast I've done from my new Vegas pad. You posted questions at https://pollgab.com/room/brento/ and I discussed the highest-upvoted ones:
https://www.youtube.com/watch?v=3wV64rqwxSk
Performance Tuning
What Do the LCK_M_SCH_M and LCK_M_IS Wait Types Indicate?
You're investigating your SQL Server's top wait stats, and you're noticing a lot of LCK% waits. Normally, that indicates blocking and deadlocks, but you're just not getting complaints from your end users, and you're wondering what's causing it.
It might be overzealous index rebuilds.
[Video] Office Hours: San Diego Office Edition
I'm back in the US at my home studio in San Diego, so I did a live Office Hours session. Post your questions at https://pollgab.com/room/brento and upvote the ones you'd like to see me cover.
https://www.youtube.com/watch?v=i-W247nIBM4
Meme Week: Setting Fill Factor to Fix Fragmentation
I just shake my head when I see people setting fill factor in an attempt to "fix" fragmentation.
The default fill factor is 100%. That means during an index rebuild, SQL Server packs 100% of your 8KB pages with sweet, juicy, golden brown and delicious data.
[Video] Office Hours: Ask Me Anything About SQL Server
You ask questions at https://pollgab.com/room/brento and I answer 'em from the beach in Cabo San Lucas:
https://www.youtube.com/watch?v=EQe6IWeTCTo
[Video] Office Hours: Ask Me Anything About SQL Server in Cabo
I watched the sun rise from my balcony in Cabo this morning and answer your questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=tNAyaTqKIpo
Performance Tuning
When Should You Use DESC in Indexes?
The short answer is that if your query orders columns by a mix of ascending and descending order, back to back, then the index usually needs to match that same alternating order. Now, for the long answer. When you create indexes, you can either create them in ascending order - which is the default: [crayon-6aafacaa5d8f4976015419/] Or…
[Video] Office Hours: Ask Me Anything About SQL Server
Let's pick up right where we left off yesterday. I've got more time and champagne, so let's keep going through your top-voted questions from PollGab.com/room/brento.
https://www.youtube.com/watch?v=raWyoVlW0lc
[Video] Office Hours: Ask Me Anything About SQL Server
I'm back in San Diego, so let's sit out on the balcony, enjoy a tasty beverage, and go through your top-voted questions from PollGab.com/room/brento.
https://www.youtube.com/watch?v=Z7xa7H2kqkQ
[Video] Office Hours in Cabo: Ask Me Anything About SQL Server
Let's get together at sunrise in Cabo San Lucas, Mexico and talk through your highest-upvoted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=sw2v_TInvac
Performance Tuning
New Year’s Resolution: Lose Weight in Your Database
Made a New Year's resolution to lose weight this year? Forget taking it off your waistline - take it off your database instead with:
sp_BlitzIndex @GetAllDatabases = 1, @Mode = 2, @SortOrder = 'size'
[Video] Office Hours: SQL Server at Sunset
Let's kick back with a tasty beverage and go through your highest-upvoted questions from https://pollgab.com/room/brento on the beach:
https://youtu.be/hwRAwhcgCGU