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

Content with tag UniqueIdentifier Rss

   Items 1 to 2 of 2   
 

proc to change PK

This script was created for a client who had uniqueidentifier PKs, but wanted to switch to BIGINT IDENTITY PK for better db performance.  Read more...
By colin_sloss 2011/03/24 | Source: SQLServerCentral.com | Category: primary key (pk)
Rating: (not yet rated) |  Discuss |   Briefcase | 891 reads

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 | 4,998 reads
   Items 1 to 2 of 2   
 
Tags
identity property (2)    
data types (1)    
database design (1)    
drop primary key (1)    
primary key (pk) (1)    
sloss (1)    
t-sql (1)