Tables are the product of normalization. Actually, it would be more accurate to say that they are the physical implementation of the product of normalization. The product is...

ebay-1087924 (10/25/2010)

---

Robert Frasca (10/25/2010)

---

I cited an example earlier where the underlying natural key changes..If you had a surrogate key you wouldn't have to do anything except possibly modify a non-clustered...

ebay-1087924 (10/25/2010)

---

True.

It promotes neither. A database using surrogate keys...

Hugo Kornelis (10/25/2010)

---

Robert Frasca (10/25/2010)

---

I'm a little hazy on what you defined as the primary key. If it's a many-to-many relationship how can the combination of the two foreign...

wagner crivelini (10/25/2010)

---

tom,

I agree.... I heard many times that the best advantage of surrogate keys is the performance improvement and this is not always true, as I intended to show...

You're...

ebay-1087924 (10/25/2010)

---

Robert Frasca (10/25/2010)

---

I'm a little hazy on what you defined as the primary key. If it's a many-to-many relationship how can the combination of the two foreign keys...

tfriedman71 (10/25/2010)

---

I agree with Quazibubbles post as well. The surrogate primary key needs to be paired with a unique key in order to maintain data integrity. This concept...

Hugo Kornelis (10/25/2010)

---

Michael Wang (10/25/2010)

---

this article serves a perfect example of data bases designed by those DBAs who understand little of the real business worlds and tend to take a...

ebay-1087924 (10/25/2010)

---

Any rule that has...

What if the natural key changes? (It can happen and it...

samalex (10/18/2010)

---

Robert Frasca (10/18/2010)

---

Just out of curiosity, is there any particular reason why the id has to be "globally" unique? Is there some reason why it can't just be...

Just out of curiosity, is there any particular reason why the id has to be "globally" unique? Is there some reason why it can't just be unique within your...

Steve Jones - SSC Editor (10/18/2010)

---

tdennis-674196 (10/17/2010)

---

I've been thinking about this issue for a few days. Like everyone, I accept that using a single integer field is going to...

Hyperdata (10/12/2010)

---

All of your comments are great! I would like to add one that I don't believe has been mentioned. Suppose a business has a database application that...