Browse by Tags

• Deadlocks
• Defensive programming
• SQL Saturday
• SQL Server
• Transact SQL

• 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. Read More... Posted Sunday, September 19, 2010 2:10 PM by Alexander Kuznetsov | 0 Comments Filed under: Defensive programming, SQL Deadlocks, SQL Saturday, SQL Server

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

  Selects under READ COMMITTED may return incorrect results if the data they select is being modified at the same time. I will provide a repro script which on my laptop returns incorrect results in more than 90% cases. Also I will provide a similar repro Read More... Posted Friday, April 10, 2009 8:34 PM by Alexander Kuznetsov | 14 Comments Filed under: SQL Deadlocks, SQL Server, Transact SQL

• Reproducing one more intermittent deadlock on only one table

  I have already described several deadlock scenarios that involve only one table in another post. This time I will describe an intermittent deadlock which occurs in high concurrency environments. Before providing a complex repro script for it, I will provide Read More... Posted Thursday, March 26, 2009 11:46 AM by Alexander Kuznetsov | 2 Comments Filed under: Deadlocks, SQL Deadlocks, SQL Server