>>Hi Einar
>>
>>http://www.sql-server-performance.com/zn_guid_performance.asp
>>
>>http://www.informit.com/articles/article.asp?p=25862&rl=1
>>
>>Interestingly enough, the second article despite proposing something faster than the GUID fails to examine the advantages of having many clients generate their own PK. I always think about the server in terms of a subway. The more people who take their time getting on and off the subway before it comes to my station, the longer I have to wait. The server could be spared the task of generating the key.
>
>Mike,
>Thanks for your reply and the links. Do you use a GUID for PK in your tables?

No, but I'm leaning that way and will be doing it in my next app. I want to test the impact, so I'll set that app up so I can switch between integers and GUIDs or even COMBS.