>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?
Einar
Semper ubi sub ubi.