I'm going to use MERGE command for loads where some tables will have about 2milions records. and incoming tables to compare will have 2 millions as well.
Do you know about any performance evaluation of MERGE command for MSSQL 2008?
(documents, blog, article, presentation, any)
MERGE manual- TechNet