Category: SSC

Tip: Schema Qualify Objects in SPs

“Eat your broccoli.” “Wear your gloves.” “Schema qualify your objects.” Your Mom wasn’t kidding, and she always gave the best advice. We’ve already seen how it would have paid off for us to end all T-SQL statements with a semicolon, even though it’s not currently required – after all, don’t CTEs and MERGE statements have […]

All Things Awesome and MidnightDBA-y – 12/2/2010

I’ve got to figure out a good way to present a regular summary of what we do every week. Until I come up with a good idea, I’ll just post it here weekly. Tomorrow (Friday) night at 11pm CST we present another stunning episode of DBAs at Midnight, this time featuring a Surprise Guest of […]