Join me on my balcony in Cabo as I review your top-rated questions from https://pollgab.com/room/brento.
Here’s what we covered:
00:00 Introductions 00:48 md: Hi Brent, as SQL Server works with 8K pages why is the recommended NTFS Unit Allocation Size for SQL volumes 64K? Wouldn’t 8K be a more efficient fit? Sneaking in a second question – I’m guessing with modern storage systems this setting doesn’t have a big impact on performance? 01:47 Ratbert: Hi Brent, is there a good way to be notified when a new table is created on production? Would like to know when