Various aspects and real-life analogies of the odds of having a hash collision when computing Surrogate Keys using MD5, SHA-1, and SHA-256.
Originally appeared here:
Collision Risk in Hash-Based Surrogate Keys
Go Here to Read this Fast! Collision Risk in Hash-Based Surrogate Keys