Surrogate/Identies for all keys

I went to a presentation the other day, the speaker suggested she always uses surrogate/integer/identity keys -- always!

This seems to be an *increasingly* common practice, with some variations using UIDs or other non-significant surrogates.

I know Joe Celko disapproves, and I find myself in complete agreement with what I've read from him on this subject. But, are we a couple of old fogies, when all the kids are using surrogate/identities all the time?

PS -- I know all of the technical arguments pro and con, I'm really asking more for a show of hands as to who does what, and secondarily about the sociology of the choice.

Joshua Stern
JRStern_at_gte.net Received on Wed Feb 07 2001 - 12:54:14 CST