Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Surrogate keys Rss

Search for any content tagged surrogate keys

   Items 1 to 3 of 3   
 

SQL Server: Natural Key Versus Surrogate Key

When designing a database to support applications you need to consider how you are going to handle primary keys. This article explores natural and surrogate keys, and discusses the pros and cons of each, allowing you to determine what makes the best sense in your environment when you are designing your databases.   Read more...
By Additional Articles 2011/02/15 | Source: Database Journal | Category: database design
Rating: (not yet rated)  Rate this |   Briefcase | 4,858 reads

Natural vs. Surrogate Keys in SQL Server : Getting the Proper Perspective

This article demonstrates the relative merits of natural and surrogate keys and benchmarks their performance in different scenarios.  Read more...
By Additional Articles 2011/01/10 | Source: SQL Server Performance | Category: database design
Rating: (not yet rated)  Rate this |   Briefcase | 3,939 reads

Enforcing Data Quality while using Surrogate Keys

Data quality is important in a database, but so many people fail to implement good referential integrity. New author Marvin Elder brings us an article that looks at surrogate keys for ensuring data quality.  Read more...
By Marvin Elder 2009/09/08 | Source: SQLServerCentral.com | Category: data modeling
Rating: |  Discuss |   Briefcase | 6,150 reads
   Items 1 to 3 of 3