• Occasionally two machines will hit the database at the same time and end up with sets of data that overlap each other causing the applications to act twice on the same row(s) of data.

    Is that SQL-92 defined concurrency and isolation level is trying to do !!! Nothing is "at the same time" at nano level.