Designing, evaluating, maintaining, and troubleshooting indexes and statistics.
568 associated posts270 primary posts
Hey, remember in yesterday's video how I said I was having a really bad day? Well, here's how bad it was - I recorded two videos in a row, and I forgot to turn my microphone on for the second video.
https://www.youtube.com/watch?v=JXcDlrLXZvw
Sometimes when people post questions at https://pollgab.com/room/brento, the answer is just a link, nothing more, nothing less. It doesn't make sense for me to rehash something that's been covered really well online, and I want to link 'em to the best resource possible. Petr: Huge slowdown of basic queries when using a partitioned table (Partition_Key…
Why yes, I'm wearing the same shirt as the video from "yesterday". Why do you ask? Stop paying attention to that, and check out the top-voted questions from https://pollgab.com/room/brento.
https://youtu.be/_vpHLQYpARM
I visited friends in Salem, Massachusetts, home of the 1692 witch trials, and it turns out Salem is a great place to visit around Halloween! There were tours, characters in costume, witch gear shops, and all kinds of spooky-themed happenings.
I sat down outside of the Charter Street Cemetery to take your top-voted questions from https://pollgab.com/room/brento:
Despite its location, Hammerfest, Norway attracts countless tourists eager to see the festival celebrating one of the world's favorite rappers. Did I get that right? I'm not sure I got that right. There's also fierce competition for the title of northernmost town: nearby Honningsvåg Norway also wants that claim, but with a population of only…
Just after passing the Arctic Circle marker and celebrating with a glass of champagne, I took your top-voted questions from https://pollgab.com/room/brento.
https://youtu.be/gyyxKrv45bQ
Come join me in my cabin aboard the Hurtigruten Nordlys, sailing up the coast of Norway, and we'll cover your top-voted questions from https://pollgab.com/room/brento.
https://youtu.be/E_JNbimkUb0
I got an interesting request for consulting, and I'm going to paraphrase it: We were using Azure SQL DB with automatic index tuning enabled for months. Things were going great, but... we just deployed a new version of our code. Our deployment tool made the database schema match our source control, which... dropped the indexes…
Pinal Dave recently ignited a storm of controversy when he quizzed readers about which one of these would be faster on AdventureWorks2019:
[crayon-6a6f35a4ebb35801050555/]
I laughed so hard when I saw the storm of responses on Twitter. People sure do get passionate about this kind of thing. If you ever wanna witness patience and generosity in action, look at Pinal's responses to this tweet.
After consuming waaaay too much coffee, I went through your top-voted questions from https://pollgab.com/room/brento:
https://youtu.be/3IyG_W7go7k
I went through the top-voted questions from https://pollgab.com/room/brento and discussed 'em live on my Twitch channel.
https://youtu.be/tyu0JN7H_hQ
Y'all posted so many good questions at https://pollgab.com/room/brento that I went longer than usual this time:
https://www.youtube.com/watch?v=f3sFkvgPPFQ
I step away from the backyard long enough to take y'all's questions from https://pollgab.com/room/brento.
https://youtu.be/xPn6wdlVgt0
There are only a couple weeks left in this summer's marathon of Office Hours sessions, which means there's limited time left to ask your toughest database problems (not trivia questions) at https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=ZVZAcE4aJPE
I took your questions from https://pollgab.com/room/brento before heading out to pick up my Cadillac from the mechanic.
https://youtu.be/B02i8Ldgy_4
Post your SQL Server and Azure SQL DB questions at https://pollgab.com/room/brento and upvote the ones you'd like to hear me discuss.
https://youtu.be/hZSavloVmuw
Seriously, how do y'all keep coming up with so many great questions? I went through your top-voted questions from https://pollgab.com/room/brento/ on a live stream on my Twitch channel, like I do on most Wednesdays & Thursdays, and really enjoyed these:
https://www.youtube.com/watch?v=qa6Ywyv39ts
Stack Overflow was down, so y'all posted questions at https://pollgab.com/room/brento and I gave 'em my best shot.
https://youtu.be/V_V245PaIYc
Y'all posted & upvoted questions at https://pollgab.com/room/brento, and we finished up the session talking about the relationships between developers and database administrators.
https://www.youtube.com/watch?v=z8prxHPF5bo
At https://pollgab.com/room/brento, post the questions you'd like to get my opinion on, and I'll take a break every now and then at the office and go through 'em.
https://youtu.be/YkruJLmhAmU
