On a nice sunny Saturday, I took the 911 around the Las Vegas canyons, and stopped to answer your top-voted questions from https://pollgab.com/room/brento:
Here’s what we covered:
00:00 Start 00:56 TheWorstDBA: I have a large table with 50 billion rows. It has a partition implemented on it, with a columnstore index. SP_BlitzIndex suggest I add a NC Index to improve performance, but when I do it slows down my queries. How can I make my queries more performant? Workload mostly reads 02:44 Jack: Hi Brent, how do you come up with ideas for blog posts and