THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » identity   (RSS)
  • Geek City: Lost Identity

    Way long ago, when Sybase first added the IDENTITY property, it took people quite a while to get the hang of using it. Along with being able to automatically generate sequential numbers for each row, we had to tune a configuration option with the geekiest of names: “Identity Burning Set Factor”.  And figuring out how to use this value seemed ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on June 17, 2014
  • 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
  • SQL Server does not care about the order of your bulk file!

    I have seen several people make this assumption over the past few weeks, and thought I should write up a little something to drive the point home.  Primarily people are expecting to take a flat file, like a log file, bulk insert it into SQL Server, and expect SQL Server to ''remember'' the original ordering of the file.  Some even go to ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on December 16, 2008
  • Programmatic Concurrency Control: Do Simultaneous Updates to Different Columns Constitute a Collision?

    In college, as part of my philosophy degree, I took a course on metaphysics. I can still vividly remember the first class. The professor presented us with a simple enough scenario:Consider a wooden boat, whose construction has just finished. Now fast-forward several months. The boat has been well used, and one of the planks that makes up its ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on July 30, 2007
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement