…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.
SQL Server
UI Fails #6 – SSMS Database Diagrams Edition
Good morning to everyone except the developer who thought these two options should go right next to each other.

DBAs hate this trick!
You have 934 total plans in your cache, with 100.00% plans created in the past 24 hours, 100.00% created in the past 4 hours, and 100.00% created in the past 1 hour.

Shout out to Brent Ozar for his outstanding First Responder Kit.
T-SQL Cheat Sheet
Need to right justify output, safely divide by zero (indoors, even!), or generate random numbers within a specified range? Check out Chad Baldwin’s excellent T-SQL Tuesday #143 – Short code examples.
Robert, are you just holding on to SQLCMD mode?

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.
You must be logged in to post a comment.