Natural Keys consist of a unique value directly related to the purpose of the row(s) related to the key. For instance, a `Clients` table might have a natural key consisting of `EmailAddress`. The opposite of a natural key is a surrogate key. See http://dba.stackexchange.com/tags/surrogate-key/...

learn more… | top users | synonyms

4
votes
1answer
176 views

Normalized Data Store - Confused with prefixes to use

I'm designing a Staging+NDS+DDS Data Warehouse system, where an ETL is going to normalize data from [Staging] and load it into [NDS], which will hold all history. I've pretty much finished the T-SQL ...
0
votes
0answers
23 views

Should a surrogate key reflect one of my columns? [duplicate]

I currently have a column called LoadID which is a surrogate key that just increment by max()+1. I also have LoadNumber which always seems to have the exact same value of LoadID, since they will ...
1
vote
2answers
270 views

Column suitable for natural key?

I have read many articles now about natural vs surrogate primary keys, and came to the conclusion there is no single best practice. I have a table that will have around 2000 definite unique values, ...
10
votes
2answers
2k views

Do natural keys provide higher or lower performance in SQL Server than surrogate integer keys?

I'm a fan of surrogate keys. There is a risk my findings are confirmation biased. Many questions I've seen both here and at http://stackoverflow.com use natural keys instead of surrogate keys based ...