Today’s questions from https://pollgab.com/room/brento require a little bit longer answers:

Here’s what we covered:

• 00:00 Start
• 03:20 Josef: What is table partitioning, and can it improve performance? Does its effectiveness depend on the underlying storage? In what scenarios is it most useful?
• 05:10 DBAMatt: If there was a new Mt. Rushmore with the heads of SQL Server pros who’ve greatly impacted the DBA world — besides Brent Ozar, obviously—who else would you wanna see up there? Maybe Itzik Ben-Gan, Ola Hallengren, Adam Machanic, Paul Randal, or the Kim Tripp?
• 07:53 DBA Magician Girl: What’s the sales pitch for SQL Server editions other than Dev, Standard, and Enterprise? I thought the others were just toys, but they’re signed up for your Constant Care.
• 12:27 Juan Pablo Gallardo: An ERP package has an internal benchmark tool for SQL “speed” that runs within the ERP, a loop read of 100k records from few tables and a few copy write, results reported in millisec time for read,write,erase. My gut tells me this test is useless, am I wrong?
• 14:32 CharoCPC: I have an 8tb DB with 2tb of free space and is part of an AG. I was thinking of truncating the largest tables, shrinking the DB, move the DB to a newly added disk, restore a copy of the DB, copy the records back into the truncated tables and rebuild indexes. Should I break the AG
• 20:34 DirtyReadsDoneDirtCheap: What common mistakes do DBAs make in their love lives? I think I’m ready to start mine.
• 24:43 MartinDBA: How many people behind Brent Ozar Unlimited kingdom? 26:54 DonKiddick: Hey Brent one of our SQL servers (SQL 2016) uses AlwaysOn to provide a read only secondary – but I’m being asked if queries being run on the secondary could force a bottleneck on the primary. Thank you for your time 🙂