InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 10:38:13 GMT20http://www.sqlservercentral.com/Forums/Topic1128289-1497-1.aspxI concur what dawalker-1068762 has said. MERGE is a wonderful command but use carefully. If the source (SRC ) table is small and light it is feasable and nice to use. But if the table has millions of rows then you will hit a performance snag.To get around this we are using MERGE along with a batch process. User very carefully! and design things in batches.Wish MERGE had a parameter to do batch processing!Mon, 20 Jun 2011 08:33:11 GMTyosiasz