Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
GUID as PK
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Miscellaneous
Thread ID:
01075523
Message ID:
01075541
Views:
16
>Who uses GUIDs for PK? Why?

Unless you want a PK that is unique across space and time, then GUID is not really necessary. Also, this takes a *lot* of space and a higher indexing overhead.

>Who prefer bigint (or int) for their PK? Why?

This is solely down to your knowledge of the application and whether you think the range of numbers offered by an Int will always be sufficient for your PK needs. Generally, I think most "normal" systems (if there is such a thing) would find Int to be perfectly acceptable for PKs. If you wanted to be doubly sure, go ahead and use Bigint as it will do no harm but, if you don't really need the number range offered by Bigint, then you are just using/wasting space in the database.
-=Gary
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform