• Checksum by itself is risky.

    Checksum in combination with the business key is less risky.

    HASHBYTES is the best for determining total and complete uniqueness if you are willing to deal with the overhead.

    Many approaches exist for SCDs depending on data volumes, load windows, and a few other factors.