• That would indeed be much faster and simpler if it wasn't for the possibility of duplicate checksums.

    This link http://ask.sqlservercentral.com/questions/7253/limitations-w-using-checksum-for-comparing-data-wh.html mentions this very problem and the only way around it is to use additional processing which adds to the complexity.