I agree as well.
>I'm in the same boat.
>
>>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.
If it's not broken, fix it until it is.
My Blog