While recovering from a nasty cold, I took your top-voted questions from https://pollgab.com/room/brento.
Here’s what we covered:
00:00 Start 03:13 Haruki Tanaka: Hi Brent, The stored procedure has 12 parameters, and users pass various combinations of values to it. I rewrote it using dynamic T-SQL, but I’m unsure how to design an effective index. A columnstore index seems inappropriate. I saw your mastering index tuning class. 04:20 Josef: Hi Brent, I’ve only worked with on-prem SQL Server. Is managing SQL in the cloud (like Azure/AWS) a big leap, or can on-prem experience carry over well? Also,