To GUID or not to GUID...that is the question....
I would sure like to have the simple ability to create new records on the fly by creating a new GUID rather than dealing with identity columns. Obviously with IDENTITY columns you have to insert a record, then get back the inserted key value (old school @@IDENTITY, the correct way SCOPE_IDENTITY). Using GUIDs you could reduce round trips to the server, but at the same time there are performance issues. You never want to put a clustered i