Not all of y’all’s questions from https://pollgab.com/room/brento require long, thought-out answers. Let’s do a speed round:

Here’s what we covered:

• 00:00 Start
• 00:34 Alain Térieur: Hi Brent. I started the restore of a (big) DB. And it took more than 2h before the resore actually started. What was SQL doing all that time? And more generally, how to know what SQL is doing in the background? And how can an admin have control over those tasks?
• 01:08 The Questioner: Hi Brent! How do I see the actual execution plan for the top query in sp_BlitzCache? To run it, I need to input parameter values. It’s harder when a procedure uses Option (Recompile).
• 01:50 Josef: Hey Brent, why do not want to have kids?
• 02:10 Mastering Columnstore Fundamentals: Is it foolish to put a non-clustered columnstore index on table with only hot data? The “Get started with columnstore indexes for real-time operational analytics” documentation’s marketing spiel sells the idea, but all of its performance tips are for columnstore with cold data.
• 02:45 Bharath Kumar : Hi Brent, I manage a 17TB DB where one table holds most of the data. Rebuilding a 3TB index offline takes ~3 days, and during that time, drive space drops significantly. The space used doesn’t match data/log/tempdb growth. How can I track where it’s going?
• 03:17 Quasi-Ted: I was hired to move a DB that is 2.5TB on a SQL 2008 Standard instance. The DB only has 400GB data (lots of dump-n-load of BLOB data). I can move it to 2022 with no issues. I cannot shrink it to get the 2TB of wasted space so I can add it to AG. Any ideas as to how to fix this?
• 04:03 DickBowen: What is the benefit of running Simple versus Full Recovery mode on databases?
• 04:48 Dopinder: What’s your favorite backup technology / software for SQL Server in context of Azure SQL VM (large multi TB database)? We use OLA scripts currently but concerned about how long it takes.
• 05:16 T-SQL Querying: Why does a too-small block size increase IO latency?
• 06:30 Culloden: Hey Brent, My company is moving analytics environment to Fabric. We plan to use SQL DB in Fabric. Do the skills developed through your courses transfer to Fabric SQL Db?
• 07:02 MyTeaGotCold: Is it still recommended to change the processor scheduling settings in Windows to give the best performance to background services? I don’t think this is Priority Boost.
• 07:42 IgniteBound: Will you be going to Ignite this year in San Francisco?
• 10:07 Dopinder: What are the top things you see people temporarily resize their Azure VM for some operation then back down after completion?
• 11:03 Steve: Hi Brent, Can you settle an age old argument…..tabs or spaces?