Repro scripts and more info for my presentation on concurrency

Alexander Kuznetsov — Sun, 19 Sep 2010 18:10:00 GMT

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

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

Search results matching tags 'SQL Server', 'SQL Deadlocks', and 'Defensive programming'

Repro scripts and more info for my presentation on concurrency