Fun with THROW: Avoid % and use semi-colons!
I talk about a couple of subtleties of THROW, and how to avoid frustrating bouts of troubleshooting.
I talk about a couple of subtleties of THROW, and how to avoid frustrating bouts of troubleshooting.
I repeat "Bad habits" advice from the past about using statement terminators and schema references to avoid debugging troubles.
Read about why you want to use statement terminators throughout all of your T-SQL code.
I talk about why every CTE I write starts with a semi-colon, and why you won't change my mind about it.
I show one way to run arbitrary SQL against objects in an arbitrary database – using nested dynamic SQL.
An index of over a decade's worth of posts and videos involving bad habits and best practices in SQL Server.
Where is my graphical ShowPlan? Many of you on SQL Server 2008 R2 are experiencing a major annoyance with SSMS since installing service pack 1 – when clicking a plan from grid results, you...
T-SQL Tuesday, the invention of Adam Machanic (@AdamMachanic), is what he calls a recurring, revolving blog party. Each month, a new host picks a topic, invites bloggers of all levels to join in, and...
Today I was in Chicago for SQLSaturday #67 to present my "What's New in SQL Server Denali" deck. You can download the deck and samples below. I mentioned during the talk that THROW is...
Earlier, I documented the system objects that have changed in Denali. One that caught my eye was a slew of new columns made available through sys.databases, mostly to support a feature I also blogged...
Sadly, THROW is not mentioned in the Programmability Enhancements (Database Engine) topic of Denali's "What's New" section. So, unless you were at PASS Summit, have been reading the various blogs from the keynotes and...
I've been fairly distracted this past week with my "Bad habits to kick" series, so apologies for being so late with the Connect digest. I stumbled upon a few pretty interesting items from the...
See why you should always use alias or column names in your ORDER BY clauses, rather than ordinal position.
I gave a presentation this morning to my bosses and co-workers explaining some of the benefits of upgrading to SQL Server 2008. I thought it might be useful to some of you if I...
When developing stored procedures, there seems to be a lot of emphasis on "get it done fast." Which means type all lower case, pay little attention to formatting, and sometimes throw best practices out...
In a recent blog post, Dancho Danchev mis-labeled a recent IIS vulnerability as a "massive SQL injection attack." Let's be honest here. Yes, this alert needs attention. But this is not a new SQL...