[Video] Office Hours: Surprise Edition

Videos
6 Comments

Y’all post questions at https://pollgab.com/room/brento, upvote the ones you’d like to see me cover, and then I talk through ’em.

There’s a slight problem with this episode: I forgot to hit the Record Questions button in PollGab, so I can’t quickly/easily generate the list of questions we covered. If you asked a highly voted question in the last week or so, it’s probably in here.

Previous Post
Is There a Bug in SQL Server’s MAXDOP Calculation? (Update: Yes!)
Next Post
[Video] Office Hours: Sponsored By Black Friday Edition

6 Comments. Leave new

  • Hi Brent! Thanks for your answer! You are right. I try to buy them all on Black Friday. Just I meant, Only the id column is sorted in the columnstore table because the source table is sorted on Id’s. The table is not sorted, This is obvious.

    Reply
  • luther atkinson
    November 9, 2022 2:20 pm

    Hi Brent, Not only are you human, you’re one of the small number of people willing to admit you made a mistake. Sometimes stuff like that happens and all you can do is admit it and move on. Good on you.

    Reply
  • Todd Chittenden
    November 10, 2022 12:45 pm

    Hello Brent, going through your Mastering Server Tuning class and just watched the one on RESOURCE_SEMAPHORE waits, particularly how column size(s) drive desired memory for a query. Was very surprised you didn’t mention this in the first answer regarding NVARCHAR(MAX) vs NVARCHAR(100).
    If I upped all my columns to (MAX), all my queries would want more memory, possibly causing this poison WAIT TYPE. Yes?
    Seems a great opportunity to switch to the pitchman voice: “And you can learn more about that in my MASTERING SERVER TUNING CLASS, available in the BLACK FRIDAY DEALS going on now at BRENT OZAR.COM!”

    Reply
    • Hahaha, thanks. The problem is that like I discussed in the call, you still have to check the length of every row and see whether or not you can drop the datatype size. It’s still a very non-trivial amount of work.

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.