title: What is the performance of "Merge" clause in sql server 2008?
body: <p>Merge can performs insert, update, or delete operations on a target table based on the results of a join with a source table. For example, you can synchronize two tables by inserting, updating, or deleting rows in one table based on differences found in the other table.</p>
  
  <p>Is anyone familiar with the performance to use "Merge" versus the traditional logic to check existence and decide the update or insert then?</p>
  
  <p>Thanks!</p>