[Video] Office Hours: Stoicism in the Home Office

I’m back in the home office this week, covering your top-voted questions from https://pollgab.com/room/brento, and we finish up the session with a discussion of the stoic habit I use to start my mornings.

Here’s what we discussed:

• 00:00 Start
• 01:42 Spicy Ninja Attack: If parameter sniffing fears justify skipping daily stats updates, should I also turn off intelligence query processing features like CE feedback unless I know they’re solving problems? Both cause recompiles.
• 03:12 Ted Striker: What are your pros / cons of periodically shrinking a SQL DB that grows large at times but then empties out quite a bit?
• 04:22 Sir Index Alot: The vast majority of our deadlock errors are resolved by indexing vs changing the underlying queries. How often do you have to change the underlying query vs indexing to fix a deadlock error?
• 06:14 AndrewG: Should I be enabling RCSI on every database? Is there any drawbacks or have seen any issues occur from it?
• 08:09 MyTeaGotCold: Now that SQL Server 2022 is finally ready, do you find that Managed Instance Link is meeting people’s Standard Edition HA/DR needs?
• 09:34 The Query Whisperer: How do your SQL AG clients deal with replicating users, permissions, agent jobs to the replicas? Run powershell script from another machine?
• 11:20 LooseCannon: I support a number of internal SQL Server-based applications. Our SQL Server is curently 2017 and our IT department is upgrading this to 2022.Given the current state of play is this a wise choice over 2025. I don’t have much influence myself on the upgrade path.