THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » sql server » Defensive progr... » Transact SQL » Database Testing   (RSS)
  • 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 ...
    Posted to Alexander Kuznetsov (Weblog) by Alexander Kuznetsov on December 14, 2008
Privacy Statement