Posted by Doug on 03/12/06 23:54

Let me try two examples.

Lets say I give you one dollar bill. Now I give you another dollar
bill. Do you immediately throw away one of them as being redundent?

Another example. "Existence" is valid data, and valid information. The
simple fact that I got a website hit is important. If I get two website
hits at the exact same time, I may still need to track that website
hit, especially if I get paid by the website hit. There may be no
unique natural key, but it is still awfully nice to have a way to
manipulate them individually if need be, and have "record" they came
in.

Finally, I don't know of any requirement that identity needs to be
unique. In fact, I think it is pretty much written somewhere in the BOL
they don't have to be, ESPECIALLY if a transaction is rolled back, or a
row is deleted.
Sequential is inconsequential. Even bad code shouldn't count on
sequential identities.

Regards,
doug miller
mba

[Back to original message]