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.
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.
Even the ID column isn’t sorted long term – again, that’s why it’s time for you to attend the classes. Thanks!
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.
Awww, thanks!
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!”
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.