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 » bad habits » identity columns   (RSS)
  • Bad Habits to Kick : Believing everything you hear or read

    I read a statement on a forum recently that said something like: IDENTITY columns are the primary key, and primary keys are clustered. Wow. My first thought was, ''I hope people aren't learning from this.'' Unfortunately, I suspect a few already have, as no matter what you write on the Internet or say in passing, at least one person ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on February 27, 2012
  • Bad habits to kick : putting an IDENTITY column on every table

    Back in October, I started a series of blog posts called ''Bad Habits to Kick,'' and thought I would revive the theme. I've worked with developers that dabble in SQL, and they tend to have a few common traits.  I'm not sure where they come from, but one that I find rather distracting is the tendency to place an IDENTITY column on every ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on February 8, 2010
Privacy Statement