Dam! I took your top-voted questions from https://pollgab.com/room/brento without making any dam or beaver puns. Rather proud of myself for that one.

Here’s what we covered:

• 00:00 Start
• 02:20 The Princess and the Frag: On SQL Server 2019 or later, are reorganising a columnstore index and triggering the tuple mover both the same thing? I thought that 2019 makes the tuple mover cleanup deleted rows, but I seem wrong.
• 03:30 TokTik: What deciding factors must one consider when marking a table for Update Statistics? How quickly does the data change, or other factors? The problem I’m trying to solve is that we UPDATE STATISTICS on our database daily/weekly, and I fear we may be doing it based on poor advice.
• 05:50 Adrian: Hi Brent. A customer wants several new features added to our product that requires some big changes to the database, but says he needs to know details of why the cost is what it is. How can I explain this to him without going into technical details? It’s frustrating.
• 09:05 BoBo: I have heard recently that people refer to MS SQL and other RDBMS as legacy databases. What makes you think if/when you hear that people call them legacy now?
• 09:59 PalmCanyon609: hi brent. i suspect that an app is executing updates, but not actually updating any data, thus thrashing the db. they’re pretty active tables, so im wondering if there’s something other than cdc or sysversioning i could use to help prove it. pesky devs..jk.
• 10:54 Don’t Bother Asking: When my friend runs sp_BlitzCache, it returns ‘forced indexes’ warnings on some trouble queries. The sql code doesn’t contain any index hints. What could potentially cause these warnings in that case?
• 11:39 Josef: Hey Brent, ConstantCare flagged a RESOURCE_SEMAPHORE wait (1h 23m) on SQL Server (v16.0.4185.3). Server has 16 GB RAM, max server memory is 11264 MB. It runs OLTP + some reporting. Would increasing memory help, or should I focus on query tuning first? Thanks!
• 12:28 MyTeaGotCold: Your ballpark figures for SQL Server licensing are great. What ballpark figures do you use for how much RAM should cost?
• 13:18 Rabelo: How to know if I have lost data after a restart on an instance with databases that have Delayed Durability Forced
• 14:21 LazyDev: Hi Brent! Re: security — I created service accounts for all SQL Server services, granted proper permissions, enabled IFI and Lock Pages in Memory. SQL uses little to no memory under that user, and queries are slow. What would a minimal checklist look like?
• 15:19 Capn BMac: Perhaps you’ve address previously and I’ve simply missed it. At some point (I’d imagine) the mighty Ozar retires from the world of databases and providing stellar support content. Is there a rising DBA star who shares your passion and talent?
• 16:40 marcus-the-german: Hi Brent, can SQL Server have to much RAM? e.g. putting a single 10 GB database on a server with 512 GB