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 » habits » identity   (RSS)
Sorry, but there are no more tags available to filter with.
  • Bad habits to kick : making assumptions about IDENTITY

    In my last post in this series, I talked about inconsistent naming conventions.  This time I want to talk about a few of the assumptions people make when using IDENTITY columns, and what kind of trouble they can cause. IDENTITY will prevent gaps A lot of people choose IDENTITY as their ''primary key'' and expect it to leave no gaps - ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on October 11, 2009
Privacy Statement