9
I recently upgraded to MSSQL 2008 R2 and was wondering whether or not the "new" Merge function was more efficient/faster than Truncating and Inserting for updating tables given each table has millions of rows. If anyone could provide some data of their performance, that would be great, but any explanation would be helpful!