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.
16 Search 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.
Connect Digest : 2011-12-01
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 #20 : T-SQL Best Practices
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...
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...
Connect digest : 2009-10-17
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...
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...