Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Guid as PK
Message
 
 
To
22/03/2010 01:44:37
General information
Forum:
Microsoft SQL Server
Category:
Database design
Title:
Miscellaneous
Thread ID:
01455992
Message ID:
01456107
Views:
41
Not sure how helpful, but take a look at this thread http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/b095b8f5-9075-46c8-b28e-0509708fa972



>Kevin,
>
>
>Beginners question...
>
>
>Are there any serious drawbacks to using a guid as a pk that you know of ?
>
>While we may get away with an int for most tables, there's one that may grow very large - if the business is successful
>
>I am thinking of making the pk of all tables guid
>
>I also want to add the possibility that someone can store a subset of the database onto his laptop, work on it, and later sync it back to the db
>
>Your opinion ?
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform