• Interesting

    More interesting if you did a batch insert test and IF EXISTS vs. UPSERT

    1 statement isn't enough to prove the point

    If UPSERT can reduce 50% read and 50% overall time, say in a million records operation, WOO HOO!

    Well, I doubt I'll see MERGE in our Production anytime soon (since SQL 2008 isn't official anytime soon either)

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005