Use of Identity Property to Resolve Concurrency Issues

At times, simple technical solutions help resolve complex problems. This is especially true for an SQL programmer, who, if he knows what he’s doing, can provide massive performance gains with the simplest of changes.

I helped resolve one such performance issue in the past. I wrote about it in a technical publication on SQL Server Central. This article can be viewed at http://www.sqlservercentral.com/articles/Locking/72142/

Advertisements