A colleague of mine insists that using surrogate keys is the common practice by an overwhelming margin in relational databases and that they are used in 99 percent of large installations. I agree that many situations benefit from them, but are they really as pervasive as he claims?