…summed up masterfully by Brent Ozar in just 45 minutes. All the ways you’re doing error handling wrong and don’t even know it, why that table valued function is going to bring the pain, and so much more. This should be required viewing for anybody who writes T-SQL.
Good morning to everyone except the developer who thought these two options should go right next to each other.
I’ve been struggling with SSMS losing intellisense, seemingly randomly, for months now. Blowing away the local settings cache and reinstalling would help for a bit, but it kept coming back, er, going away. I was losing my serenity. Special thanks to my friend Capt’ Quacks for figuring out that intellisense and SQLCMD mode don’t play well together.