What should I choose for my primary key?

Naturals? Idents? GUIDs? Oh, jeez. Getting an official opinion on which to use is about as hard as getting a lawyer to tell you exactly when its okay to shoot somebody. NOBODY wants to give you a straight up answer. And you can understand why; there are many different things you have to consider, each of which can take you in a completely different direction. This article is an excellent listing of each type and its pros and cons. Protip: Idents are your best bet. From www.codinghorror.com.