Tag: IDENTITY

SWITCHing IDENTITY in the Pub

I was recently talking to a friend in our local pub about a problem he had with tables not using¬†IDENTITY columns. His application was incrementing the max value of the ID column in each table by 1. This isn’t particularly efficient and it’s potentially open to race conditions. As we moved onto our 2nd ale […]

Sign Up

James Anderson SQL Server DBA

Hi, I'm James Anderson. When I'm not blogging about SQL Server, I do this.

DBA Stackexchange Profile