SELECT FOR UPDATE with SQL Server
Recently I had a deadlock problem because Sql Server locks more then necessary (page). You can’t really do anything against it. Now we are catching deadlock exceptions… and I wish I had Oracle instead. Edit: We are using snapshot isolation meanwhile, which solves many, but not all of the problems. Unfortunately, to be able to … Read more