THE SQL Server Blog Spot on the Web

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

Alexander Kuznetsov

Repro scripts and more info for my presentation on concurrency

Yesterday I delivered a session named "Developing T-SQL to survive concurrency" at East Iowa SQL Saturday. Thanks to everyone who attended, and thanks to Michelle Ufford, Chris Leonard, Ed Leighton-Dick, and other volunteers, who organized the event.

As promised, here are the links with more information and more repro scripts, more or less in the order following the order of the presentation.


Selects under READ COMMITTED and REPEATABLE READ may return incorrect results.


Reproducing deadlocks involving only one table


Reproducing deadlocks involving only one table


Retrying after deadlocks leads to lost updates


Patterns that do not work as expected.


Developing Modifications that Survive Concurrency


And, finally, Erland Sommarskog's article Arrays and lists in SQL


Published Sunday, September 19, 2010 2:10 PM by Alexander Kuznetsov

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS


No Comments

Leave a Comment


About Alexander Kuznetsov

Alex Kuznetsov has been working with object oriented languages, mostly C# and C++, as well as with databases for more than a decade. He has worked with Sybase, SQL Server, Oracle and DB2. He regularly blogs on, mostly about database unit testing, defensive programming, and query optimization. Alex has written a book entitled "Defensive Database Programming with Transact-SQL" and several articles on and Currently he works as an agile developer.

This Blog


Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement