[Video] Office Hours in My Vegas Backyard
I'm doing a lot of travel this month, but I took a break in my Vegas backyard to go through the top-voted questions from https://pollgab.com/room/brento.
https://youtu.be/3ez2m-Hev9E
Indexing and Statistics
Designing, evaluating, maintaining, and troubleshooting indexes and statistics.
568 associated posts270 primary posts
[Video] Office Hours: Back in the Home Office
I'm back home after a 2-week Iceland vacation. Let's catch up with your top-voted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=PV6MuFQkf5k
[Video] Office Hours: Waiting for the Hot Tub to Fill
While waiting for my Husavik hot tub to fill up, I took your top-voted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=f0chyzVLFYw
[Video] Office Hours: Philosophical Questions at the Waterfall of the Gods
I'm in Iceland this week, land of fire and ice, a place I keep coming back to over the years. It's one of my favorite places on earth with stunning scenery, nice folks, and great restaurants. I paused at Godafoss to take your top-voted questions from Pollgab.com/room/brento.
https://www.youtube.com/watch?v=nGoE17cSdl8
Office Hours: Unusual Beach Chair Edition
When you think 'beach chair', this probably isn't what you think. I'm at a black sand beach on the south coast of Iceland, answering your top-voted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=5j4TIuC54ak
Vertical Partitioning Is Almost Never the Answer. Here’s Why.
You're looking at a wide table with 100-200 columns.
Years ago, it started as a "normal" table with maybe 10-20, but over the years, people kept gradually adding one column after another. Now, this behemoth is causing you problems because:
[Video] Office Hours: Hawaiian Edition
I took your top-voted questions from https://pollgab.com/room/brento and answered 'em from my balcony at Disney's Aulani Resort in Hawaii. I'm not really a Disney guy - we were there for a friend's birthday celebration - but I tell ya what, that's my new favorite resort in the world. The water park, food, beach, and nearby activities were great, and it has the awesome Disney service. Top notch. Anyhoo, back to tech:
[Video] Office Hours and an AI-Generated Sweatshirt
I originally took these questions from https://pollgab.com/room/brento poolside at the Trixie Motel (really), but I forgot to use the good microphone, so I re-recorded 'em from my home studio when I got back:
https://www.youtube.com/watch?v=8booXqUYY-Y
Index Rebuilds Make Even Less Sense with ADR & RCSI.
Accelerated Database Recovery (ADR) is a database-level feature that makes transaction rollbacks nearly instantaneous. Here's how it works.
Without ADR, when you update a row, SQL Server copies the old values into the transaction log and updates the row in-place. If you roll that transaction back, SQL Server has to fetch the old values from the transaction log, then apply them to the row in-place. The more rows you've affected, the longer your transaction will take.
Performance Tuning
What If You Need to Index a Lot of Duplicate Data?
Let's get a little nerdy and look at database internals. Create two tables: one with a million unique values, and one with a million identical values:
[crayon-6a6ef82e05769736845829/]
[Video] Office Hours: Long Answers Edition
Today's questions from https://pollgab.com/room/brento require a little bit longer answers:
https://youtu.be/W-HKNMh8JQE
[Video] Office Hours in Tokyo, Japan
For the last Office Hours of the year, I'm coming to you from Tokyo, the last stop on my 3-week tour of China and Japan. This was a big Epic Life Quest task for me, for sure, something I've wanted to do for decades. Let's bring you along and go through your top-voted questions from https://pollgab.com/room/brento:
[Video] Office Hours at the Petit Ermitage in LA
I went to LA for the opening week of Somni, a gorgeous restaurant in LA, and took your questions from the rooftop deck of the adorable Petit Ermitage hotel.
https://www.youtube.com/watch?v=0MtdQkAw9a8
[Video] Office Hours: Ask Me Database Questions
I took your top-voted questions from https://pollgab.com/room/brento. At one point, my camera overheats - hang in there, I get it fixed in a few seconds.
https://www.youtube.com/watch?v=PC9JokmIkuM
Office Hours: Guess the Theme Edition
There's a secret theme to the questions I hand-picked from the queue at https://pollgab.com/room/brento. Normally I just take the top-voted ones, but today, see if you can spot the thing they all have in common:
https://www.youtube.com/watch?v=reaEWQ1TzLg
[Video] Office Hours: SQL Server Questions and Answers
That face I'm making in the video thumbnail is priceless. YouTube randomly picks these, and I laughed out loud at this one. Anyhoo, let's get to answering your top-voted questions from https://pollgab.com/room/brento:
https://www.youtube.com/watch?v=a0zOllaozX4
Office Hours in the Valley of Fire
I took the Graffiti Gulf 356 out to the Valley of Fire State Park to exercise it, and took your top-voted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=cr3s9nSagW8
[Video] Office Hours: Salem Witchcraft Edition
It's spooky time again! I visited Salem, Massachusetts again this year, this time for a friend's wedding. I ended up in the same spot next to the Charter Street Cemetery that I filmed at last year! I went through your top-voted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=Q4WtTm3O4bA
Performance Tuning
How Many Indexes Is Too Many?
Let's start with the Stack Overflow database (any size will work), drop all the indexes on the Users table, and run a delete:
[crayon-6a6ef82e05d33265118140/]
[Video] Office Hours: Open Q&A About Databases
I went through your top-voted questions from https://pollgab.com/room/brento plus hit live ones from the TikTok viewers.
https://www.youtube.com/watch?v=XDx-OnTHezA
