Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
GUID as PK
Message
 
To
06/12/2005 17:38:54
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Miscellaneous
Thread ID:
01075523
Message ID:
01075527
Views:
26
>>Can I get a show of hands? <s> (Michal should implement a voting system)
>>
>>Who uses GUIDs for PK? Why?
>>Who prefer bigint (or int) for their PK? Why?
>
>We already have the entire infrastructure for such needs. If you feel you would have relevent questions in regards to such topics, I would be happy to release a survey about it. Basically, you could send me by email a list of questions with the choices.
>
>As for the question, I used GUID in one table but it is because the foreign provider required it in their own database structure. So, they wanted me to have such a field ready when they were getting the data by XML.
>
>I always use Integer.

I think I know what you are thinking about, but I was thinking of a much simpler system with only two (or maybe three) possible answers (Yes, No, Doesn't matter to me).

Example:
Q: Do you prefer a GUID as a PK over bigint or int?
A: Check one: Yes , No, Unsure
Result: 10% Yes 89% No 1% Unsure (2,000 people responded)

Very un-scientific but maybe a little usefull :)

Thanks for your vote.

Einar
Semper ubi sub ubi.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform