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

Content with tags Strategies, Basics, Naming Standards Rss

   Items 1 to 2 of 2   

A Lookup Strategy Defined

Most databases designs nowadays seem to have at least a few if not many lookup or reference tables. This article helps you define a strategy in how to design, approve, and deploy them.   Read more...
By David Sumlin 2003/02/20 | Source: | Category: basics
Rating: |  Discuss |   Briefcase | 12,504 reads

Using Uniqueindentifier Instead of Identity

Identity columns are last years news. Have you experimented with uniqueindentifiers - better known to programmers as GUID's? Guaranteed to be unique in the world, they offer a powerful alternative to identity columns.   Read more...
By Andy Warren 2001/09/17 | Source: | Category: basics
Rating: |  Discuss |   Briefcase | 11,413 reads
   Items 1 to 2 of 2   
database design (2)    
datatypes (1)