Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
GUID or Identity?
- Thread starter OOzy
- Start date
IN general, I use indentity fields, they take up less space and join faster. GUIDs are more necessary if you are trying to coordinate data between multiple servers so that you can guanantee the number is unique no matter which server it was created on. So if you have a server that the northeast region enters their data on, and one the south east enters their data on and a central one whic is updated from the filed servers using replication, then a guid is a good idea.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question