On May 10, 2008, at 6:46 AM, Jonathon -- Improov wrote:
Chris Howe mentioned this quite a few times, about keeping primary keys clean and not incorrectly coupled to interpreted application data. But Chris is probably a database designer.
Personally I'd rather go with recommendations from someone like Joe Celko (or many other great experts, teachers, and authors like him)... Meaningless (ie artificial) primary keys are usually a very poor alternative to a well defined composite primary key.
-David
