Category: Tips

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 […]

Ground Zero Database Design: Part 2

Last week I wrote Ground Zero Database Design, thinking that was a good enough bare-bones intro (with recommended reading!) that I could leave the subject alone for a while. Then I went looking through my blog ideas folder, and found this: DB design note:A column must mean what it means always, not just in steps […]

Forgotten T-SQL Cheat Sheet

You’ve seen the blog, you’ve downloaded the code…you even watched the 24HOP session recording…now own the Forgotten T-SQL Cheat Sheet! Yessir, this handy-dandy reference sheet includes the Logical Processing Order of SELECT, shorthand for recursive CTEs and MERGE, the famous list-of-details XML trick, and more! And it’s yours, for only $199.99! FREE!  Why? Because we […]