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.
14 Search results
14 results for the term semi-colon:
Bad habits: Another case for semi-colons and schema prefix
I repeat "Bad habits" advice from the past about using statement terminators and schema references to avoid debugging troubles.
Ladies and gentlemen, start your semi-colons!
Read about why you want to use statement terminators throughout all of your T-SQL code.
Why I always start CTEs with a statement terminator
I talk about why every CTE I write starts with a semi-colon, and why you won't change my mind about it.
"I want to do X to all the Ys in database Z" – Part 1
I show one way to run arbitrary SQL against objects in an arbitrary database – using nested dynamic SQL.
Bad Habits and Best Practices
An index of over a decade's worth of posts and videos involving bad habits and best practices in SQL Server.
T-SQL Tuesday #20 : T-SQL Best Practices
T-SQL Tuesday, the invention of Adam Machanic, 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 then...
SQLSaturday #67, Chicago: "What's New in SQL Server Denali"
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...
SQL Server v.Next (Denali) : How has sys.databases changed?
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...
SQL Server v.Next (Denali) : Exploring THROW
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...
Bad Habits to Kick : ORDER BY ordinal
See why you should always use alias or column names in your ORDER BY clauses, rather than ordinal position.
My reasons for upgrading to SQL Server 2008
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...
My stored procedure "best practices" checklist
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...
Call a spade a spade! (SQL injection, or IIS vulnerability?)
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...