SQLServer - MERGE with condition is slow

SQLServer - MERGE with condition is slow

References

Reference NO 1

http://stackoverflow.com/questions/15206075/sqlserver-merge-with-condition-is-slow-even-an-always-false-condition

Reference NO 2

http://technet.microsoft.com/en-us/library/cc879317(v=sql.105).aspx

Reference NO 3

http://www.mssqltips.com/sqlservertip/2883/using-the-sql-server-merge-statement-to-process-type-2-slowly-changing-dimensions/

Reference NO 4

http://www.sqlservercentral.com/Forums/FindPost1361447.aspx

Reference NO 5

http://bytes.com/topic/sql-server/answers/82157-update-sql-server-2000-slow

Reference NO 6

http://dba.stackexchange.com/questions/30633/merge-a-subset-of-the-target-table

Reference NO 7

http://sqlserverplanet.com/sql-2008/sql-server-merge-statement

Reference NO 8

http://www.sqlrepl.com/sql-server/creating-mergereplication-conflict-alerts/