Edward Robertson

less info
446 reputation
33
bio website
location Atlanta, GA
age 42
visits member for 2 years, 8 months
seen Mar 1 '13 at 21:28

Nov
10
awarded  Yearling
Nov
10
awarded  Yearling
Nov
22
awarded  Supporter
Nov
22
comment What is the best way to design a table with an arbitrary id?
@P.Brian.Mackey - The 'uniqueidentifier' (props @JDT) type has been around since at least SQL Server 2000, possibly before, and it's purpose is for storing GUIDs:"SQL Server 2000 - The uniqueidentifier data type stores 16-byte binary values that operate as globally unique identifiers (GUIDs)." msdn.microsoft.com/en-us/library/aa223933(v=sql.80).aspx
Nov
22
comment What is the best way to design a table with an arbitrary id?
NOTE: a GUID is not a string, it is binary data that is displayed as a string for humans. Please do not store a GUID as a string in the database. Both SQL Server and Oracle have ways of storing GUIDs in their binary form (I'm not sure about other DMBSs), and they are much more efficient in terms of both speed and size if represented correctly as binary data.
Nov
11
awarded  Good Answer
Nov
10
awarded  Nice Answer
Nov
10
awarded  Teacher
Nov
10
answered Why am I seeing so many for(;;) constructs?