SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
Home Articles Editorials Forums Scripts Blogs QotD Books SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us


 

Articles with tags Data Types, Database Design, T-SQL Rss

Refine your search with one of the following additional tags (with number of items):

IDENTITY (1)    
Performance Tuning (1)    
UniqueIdentifier (1)    

Search for any content tagged Data Types & Database Design & T-SQL

   Items 1 to 3 of 3   
 

Auto generated SQL Server keys - uniqueidentifier or IDENTITY

I'm designing a table and I've decided to create an auto-generated primary key value as opposed to creating my own scheme or using natural keys. I see that SQL Server offers globally unique identifiers (GUIDs) as well as identities to create these values. What are the pros and cons of these approaches?  Read more...
By Additional Articles 2008/10/23 | Source: MSSQLTips.com | Category: T-SQL
Rating:  Rate this |  Briefcase | 3,212 reads

TinyInt, SmallInt, Int and BigInt

SQL Server guru David Poole takes a look at the different integer data types and the impact of each of those on your database.   Read more...
By David Poole 2006/12/18 | Source: SQLServerCentral.com | Category: Performance Tuning
Rating: |  Discuss |  Briefcase | 16,246 reads

TinyInt, SmallInt, Int and BigInt

SQL Server guru David Poole takes a look at the different integer data types and the impact of each of those on your database.   Read more...
By David Poole 2006/12/18 | Source: SQLServerCentral.com | Category: Performance Tuning
Rating: |  Discuss |  Briefcase | 16,246 reads
   Items 1 to 3 of 3   
 
 
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use