SQL Server Identity column FAQshttp://blogs.msdn.com/b/sqlprogrammability/archive/2006/04/04/567724.aspxQ. How is identity values generated? Does SQL Server internally use lock as synchronization mechanism? A. Identity values are generated in-memory using light-weight synchronization, i.e. Spinlock (roughly speaking, Interlocked* function with yielden-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875) SQL Programmability amp API Development Team Blog SQL Server Identity | Green Tea Fat Burnerhttp://blogs.msdn.com/b/sqlprogrammability/archive/2006/04/04/567724.aspx#9717729Tue, 09 Jun 2009 22:25:45 GMT91d46819-8472-40ad-a661-2c78acb4018c:9717729 SQL Programmability amp API Development Team Blog SQL Server Identity | Green Tea Fat Burner<p>PingBack from <a rel="nofollow" target="_new" href="http://greenteafatburner.info/story.php?id=2214">http://greenteafatburner.info/story.php?id=2214</a></p> <img src="http://blogs.msdn.com/aggbug.aspx?PostID=9717729" width="1" height="1">Multi thread inserts into a table with Identity column as primary | keyongtechhttp://blogs.msdn.com/b/sqlprogrammability/archive/2006/04/04/567724.aspx#9338156Sun, 18 Jan 2009 19:29:50 GMT91d46819-8472-40ad-a661-2c78acb4018c:9338156Multi thread inserts into a table with Identity column as primary | keyongtech<p>PingBack from <a rel="nofollow" target="_new" href="http://www.keyongtech.com/2166106-multi-thread-inserts-into-a">http://www.keyongtech.com/2166106-multi-thread-inserts-into-a</a></p> <img src="http://blogs.msdn.com/aggbug.aspx?PostID=9338156" width="1" height="1">