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

Content with tags Database Design, Surrogate keys Rss

   Items 1 to 2 of 2   
 

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,825 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,898 reads
   Items 1 to 2 of 2   
 
Tags
natural key (1)