• I think that GUIDs are more valuable than most people give them credit for.  There is a debate about the performance impact but if used wisely to set up a good live archive system then performance in the primary production DB will improve.  I also like to use GUIDs on frequently updated records and rows.  Instead of doing record locking I update the GUID after every update...  my business layer has the ability to display the differences to the losing update.