New answers tagged isolation-level
You will be able to avoid a lot of your race conditions by performing many of your steps in a single statement. By using a TOP() cluse will be able to set the flag on at most one row. By using the OUTPUT cluse you can return this to the application automically. I define a simple test table and populate it: create table dbo.T(id int, IsProcessing bit ...
Top 50 recent answers are included