I did a lot of research on this 3-4 years ago the online comunity does not agree on the guid vs. int PK. IMHO I think the speed and size benefits of int PK are far outweighed by the general maintenance and replication and/or offline access of the guid PK.

There was one article on how you could change the structure of the guid to make it faster, but I never pursued that.

>That's right, I remember those now. I'll have to throw that around in my head to see if I would benefit from this.
>
>>Yes, I use uniqueidentifier for my PK. Actually, GUIDs are preferred if you need replication and/or offline access.
>>
>>>Do you use SQL Server uniqueidentifier type as your Primary Keys? I did a little research on that a few weeks ago and found that identity integers were perferred, but ASP.NET Membership uses uniqueidentifier.