Learning more about Primary Keys

How much do you know about Primary Keys?  Do you know why they exist?  Ric Van Dyke is here to tell us and you might be surprised to know what he thinks Primary Keys should be too!  Also, read the comments and see if you agree with some of the conversation going on there and maybe even pick up a few additional ideas too!

Weekend Mystery: Primary Key Indexes

A few months ago I read this article from Arup Nanda, but it wasn't until re-reading it tonight that the lesson he was teaching us really sunk in for me.  If a table has a primary key, you'd naturally think that duplicate values can't exist as the primary key right?  WRONG!  Arup shows us exactly why, as well as explaining why this is actually desired in some situations which taught me even more.  Explore the mystery this weekend!