Home Forums Article Discussions Article Discussions by Author Discuss content posted by Wagner Crivelini Do You Really Need Surrogate Keys? Part 1 – Concepts and Methods RE: Do You Really Need Surrogate Keys? Part 1 – Concepts and Methods
tonyrogerson-498793
SSC Enthusiast
Points: 189
More actions
October 25, 2010 at 1:04 am
#1241436
I wrote a blog article a while back on the theory on surrogate keys based around Codd and Date.
The link: http://sqlblogcasts.com/blogs/tonyrogerson/archive/2010/03/13/database-design-surrogate-keys-part-1-of-many-rules-for-surrogate-keys-e-f-codd-and-c-j-date-research-and-problems-they-solve.aspx
Reminds me - I need to go back and finish the other parts I said I would.
Surrogates are a good thing and save us from all sorts of problems.
Tony.