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 additional CPUs?
- 15:45 Recap