>Hi Naomi,
>
>>Would you please list all the advantages vs. disadvantages of GUID vs. Integer (in your opinion)?
>
>Advantages:
>
>GUIDs can be generated on the client without additional traffic to the server. Generating keys on the client avoids the need for translating primary keys when inserting data.
>
>GUIDs can be used in replication and offline scenarios
>
>GUIDs do not require a serialization of key generation requests and are therefore by definition scalable
>
>GUIDs values are vastly distinct which distributes values over indexes
>
>GUIDs discourage that developer from using the PK for anything but the PK
>
>
>Disadvantages:
>
>GUIDs values are vastly distinct which distributes values over indexes
>
>GUIDs require more storage space (though not that much(
>
>GUIDs require more I/O resources
>
>For testing queries you have to copy and paste the key instead of reading and typing. You can't really write it on paper if you work with paper a lot.

Thanks a lot.