May 20, 2003 at 8:06 am
We are doing something that is data driven and need to use GUID for unique identifier(dont want to use identity,but may reconsider). This will never be used by the developers though. Any problems with using GUIDS ?
thanks
-sk
May 20, 2003 at 9:26 am
The main considerations for us have been size and randomness. Just make sure you don't put a clustered index on the GUID things have generally worked well for us.
Guarddata-
May 20, 2003 at 12:57 pm
guarddata, Why not a clustered index? Purly because of the work SQL will have to do during inserts / deletes?
If the table does not that busy with inserts and deletes would a clustered index not be better assuming you are going to use that column on joins?
Just curious. 🙂
Cheers,
Crispin
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply