Want to ask your own questions or pick the ones I discuss? Head over to https://pollgab.com/room/brento to get involved. In the meantime, let’s hang out in the backyard, where Beni makes a special guest appearance.

Here’s what we covered:

• 00:00 Start
• 00:57 Old and Tired DBA: Should I convert all of my parameters to local variables in my stored procs?
• 02:21 MyTeaGotCold: Do you ever use hints like ASSUME_MIN_SELECTIVITY_FOR_FILTER_ESTIMATES or ASSUME_JOIN_PREDICATE_DEPENDS_ON_FILTERS? They’ve saved me a few times, but I think they’re not in most people’s toolbox.
• 03:42 emre: We have a problem with VMware snapshot creation: Unable to quiesce on SCV: Exception occurred when quiescing virtual machines. Is using a newer version of SQL Writer without updating MS SQL Server possible? Is it a real thing? Thanks
• 07:00 I_like_SQL_Server: Hi Brent, what is your favorite Tequila drink? (I’m posting this on a Friday so it’s legit.)
• 09:45 I_like_SQL_Server: Hi Brent, I’m struggling with setting up proper statistics handling and wonder if you have any updated resources or planning on statistics maintenance? We have some large tables (for us a couple of terabytes is large) and it’s hard planning the correct sample rate.
• 11:40 Elwood Blues: What are your pros / cons of SQL backup to disk vs back up to URL in context of Azure SQL VM? (Speed, cost, reliability,etc)