Hi david,

>> ALso, I use GUIDs, which some see as a lot of extra baggage but in my case was the quickest way for me to get where I needed.

>Do you use GUIDs to join multi-million row tables to other multi-million row tables?

>That just seems totally impractical to me in terms of disk space and I/O compared to using a 4 byte integer value.

In a highly distributed database where loose coupled replications is used, using GUID might be your best bet to prevent duplicate keys.

Walter,