> it is isn't atomic merge is a single, logically-atomic statement in sql server (with or without hints) it doesn't have the same physical locking characteris

> it is isn't atomic merge is a single, logically-atomic statement in sql server (with or without hints) it doesn't have the same physical locking characteristics as a single insert or update statement, how could it?