Scott Mitchell writes about the different types of database primary keys in Techniques for Uniquely Identifying Database Records. In couple of pages he covers almost anything a developer should know about PK in his every day job.