Question : A while back, I asked if surrogate keys provide better performance than natural keys in SQL Server. @sqlvogel […]
Tag: natural-key
coping with long natural string key
Question : I have inherited a (quite) big database (for my standards at least, since by no means I call […]
Foreign keys – link using surrogate or natural key?
Question : Is there a best practice for whether a foreign key between tables should link to a natural key […]
Column suitable for natural key?
Question : I have read many articles now about natural vs surrogate primary keys, and came to the conclusion there […]
Good Natural Key For a Physical Mailing Address
Question : I’m trying to figure out what a good natural key for a Physical Mailing (PO Box) address would […]
Foreign keys – link using surrogate or natural key?
Question : Is there a best practice for whether a foreign key between tables should link to a natural key […]
Surrogate key vs Natural key
Question : I have a table called devices. Most of the devices that will get stored in this table can […]