You upvoted questions at https://pollgab.com/room/brento, and today I’m at the harbor in Heimaey to cover ’em.
Questions we talked through:
00:00 Introductions 01:00 Zach: What happens when I change a VARCHAR(MAX) to VARCHAR(2500)? 04:26 Scott: What tools do you recommend for tracking down locks involved in blocking? 07:23 Pointing out the beluga whale sanctuary 07:58 Ice Horse Rider: Why aren’t you a Microsoft MVP? 10:20 Kirby: What does changing MAXDOP do? 12:44 Mr SQL Seeks: Should I upgrade to 2017 or 2019? What compat level do I use? 14:19 Farooq: How do I get notified when SQL Server needs