Stress testing UPSERTs

Suppose that you need to implement the following logic: IF(row exists) Update the row ELSE Insert a new row. If you already are on 2008, you should use MERGE command, and you don't need to read this post. Prior to 2008 this logic has to be implemented using UPDATE and INSERT commands. I will stress test several UPSERT implementations in a high concurrency environment. I will demonstrate that under most circumstances the best approach is to serialize your modifications. Prerequisites The following...(read more)

Source Click Here.