[Video] Office Hours: SQL Server 2008 R2 Edition, I Guess
I went through your highest-voted questions from Pollgab and talked through 'em, and strangely, there was a bit of a 2008R2 theme!
https://youtu.be/3-B5L3Komq4
Indexing and Statistics
Designing, evaluating, maintaining, and troubleshooting indexes and statistics.
568 associated posts270 primary posts
[Video] Office Hours Speed Round: 17 Answers in 11 Minutes
Not all of your questions need detailed answers. In this speed round, I race through 18 answers in 11 minutes:
https://www.youtube.com/watch?v=VaujdF1wp8w
[Video] Office Hours on the Balcony Part 2
Picking up right where we left off yesterday, we continue down through the not-so-highly-upvoted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=saIwheS6_Mg
Performance Tuning
NOLOCK Is Bad And You Probably Shouldn’t Use It.
When you put NOLOCK in your query, SQL Server will:
Read rows twice
Skip rows altogether
Show you changes that never actually got committed
Let your query fail with an error
[Video] Office Hours on the Balcony Part 1
I hang out on my balcony in San Diego with a gin & tonic and a bunch of your highly upvoted questions from https://pollgab.com/room/brento.
https://youtu.be/kAzUupChX_Y
[Video] Office Hours at Silver Strand State Beach: Ask Me Anything About SQL Server
It's a beach day! Let's hang out at Silver Strand State Beach and I'll take your highly voted questions from https://pollgab.com/rooms/brento.
https://www.youtube.com/watch?v=qTocbvnQgFs
[Video] Office Hours: Ask Me Anything About SQL Server
It's time for the first live Office Hours in my new home studio in San Diego! I took your highest-upvoted questions from https://pollgab.com/room/brento/ and answered 'em:
https://www.youtube.com/watch?v=1ZS3Hcpry_A
[Video] Office Hours: Ask Me Anything On the Balcony
Good evening, party people! I finally have my new San Diego home base all set up and unpacked, so I took a champagne break to review your top-rated questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=ESHC8NZKf5E
[Video] Office Hours: Ask Me Anything About SQL Server at Vestrahorn
The beach at Vestrahorn mountain looks different every time we've visited: high tide, low tide, sun, clouds. Always a fun side trip when we're out in the southeast of Iceland. I took a break to answer the questions you upvoted here.
https://www.youtube.com/watch?v=TE2y8nKioG8
[Video]: Office Hours at Diamond Beach
I took a break from playing with glacier leftovers at Diamond Beach to answer the questions you upvoted at https://pollgab.com/room/brento/.
https://www.youtube.com/watch?v=K4l522V4h08
[Video] Office Hours at the Seltjarnarnes Lighthouse
You posted and upvoted SQL Server questions at https://pollgab.com/room/brento, and I went out for a walk on the Seltjarnarnes peninsula to the lighthouse to answer 'em.
https://youtu.be/IB2EH2irD6s
[Video] Office Hours: Ask Me Anything About SQL Server at Hallgrímskirkja
I hang out by Hallgrímskirkja, the modern church in Reykjavik, and take your highly-voted questions from https://pollgab.com/room/brento. Here's what we covered:
https://www.youtube.com/watch?v=slku6V9mWnw
[Video] Office Hours: Ask Me Anything About SQL Server, Mink Edition
In this episode, I've got my own question: what's this animal running around at my feet? Commenters on the YouTube video explained that it's a mink. They were imported into Iceland in the 1930s for their fur, and they escaped out into the wild. The country's been trying to reduce their population, and they've even been part of the COVID19 news.
[Video] Office Hours: Ask Me Anything About SQL Server
You've got questions, I've got answers. Welcome to another edition of Office Hours, where you post your questions here, upvote the ones you'd like to see me talk through, and I do your bidding:
https://www.youtube.com/watch?v=Akg7fguhz2I
Performance Tuning
You Probably Shouldn’t Index Your Temp Tables.
When you've got a process that uses temp tables, and you want to speed it up, it can be tempting to index the temp table to help work get done more quickly. However, in most cases - not all, but most - that's a bad idea. To explain why, I'm going to take a large…
[Video] Office Hours: Ask Me Anything About Microsoft SQL Server
Got questions that aren't a good fit for DBA.StackExchange.com, and you want my opinion? Post them here and upvote the questions you'd like to see me talk through. This weekend, I hopped into my home studio and did a half-hour session because so many good questions had piled up:
https://www.youtube.com/watch?v=j7XFeXcOZgU
[Video] Office Hours: Ask Me Anything About Microsoft SQL Server
We took a break from roaming around Iceland long enough to check in at our home studio. While we were here, I did a live Office Hours session, taking your questions about Microsoft SQL Server.
https://youtu.be/MBPSFuVOFKk
[Video] Office Hours: Arctic Circle Puffins Edition
Erika and I are on the road in Iceland, roaming around the countryside, and I'm taking you with us. We visited Grímsey, a tiny island on the Arctic Circle, home to gazillions of sea birds like puffins and arctic terns. I took about half an hour to answer your most highly-voted questions from here:
[Video] Office Hours: Siglufjörður Airport Runway Edition
Erika and I are on the road in Iceland, roaming around the countryside, and I'm taking you with us. This session was shot in Siglufjörður, a beautiful little oceanfront fishing village in the north.
Yes, I'm on the airport runway. No, seriously. Here's what it looks like from the air in the winter.
[Video] Office Hours: Ask Me Anything About SQL Server
Erika and I are on the road in Iceland, roaming around the countryside, and I'm taking you with us. This week, we're in Siglufjörður, a beautiful little oceanfront fishing village in the north. In the mornings, before Erika wakes up, I'm filming Office Hours videos to answer your questions that you post here. The first video comes to you from a park bench next to the harbor:
