THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Best Practices » future-proofing   (RSS)
  • Bad habits to kick : ORDER BY ordinal

    A few weeks ago, I wrote a post about forming a new habit: always terminate statements with semi-colons.  Today I thought I would start a series on kicking bad habits that many of us have developed over time.  I provided a little more background on this series over on my company's site.  Today's topic: using ordinal numbers in our ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on October 6, 2009
  • Ladies and gentlemen, start your semi-colons!

    Almost a year ago now, I wrote up a blog post detailing the things that I strive to do when writing T-SQL modules (mostly stored procedures). One of the things that I have been doing since my very first common table expression (CTE) back in the Yukon beta is ending all relevant statements with statement terminators (semi-colons).  A few ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on September 3, 2009
Privacy Statement