On an overcast morning in scenic Camden, Maine, I stood on the docks and took your top-voted questions from https://pollgab.com/room/brento.
Here’s what we covered:
00:00 Start 00:54 Alma Fahlstrøm: Does index fragmentation matter with column store indexes on SQL 2019 / NVME San storage? 01:22 Miss Minutes: What is your recommended way to find the slowest queries with plan warnings? 01:58 Renzi: What is your opinion of using Azure managed disks vs Azure storage account for use with Azure SQL VM? 02:24 Beta Ray Bill: What are your thoughts on enabling Locking Pages in Memory for