>>PKs are used to enforce referential integrity so they only have to be unique. Where they are generated is a different issue. Right?
>
>I guess that's a matter of opinion.
They are clearly two different tasks, but I'll let you off the hook. ;) Here's some food for thought, though. If natural keys are used they certainly would exceed 16 bytes after a child table. So guids are better than natural keys even for joins.
Here's a way to offset some of the performance issues.
http://www.informit.com/articles/article.asp?p=25862Thanks for your time!
>
>>
>>Integer performance is good, but why does SQL's newid function generate guids?
>
>That's a question for the SQL Server team.