The most efficient way to store a GUID value in the SQL Server database

advertisements

Say, if I need to store non-repeating GUID values (something like {AB50C41E-3814-4533-8F68-A691B4DA9043}) in the SQL Server database, what is the most efficient way to define the column to store it? (i.e. as string, a blob, or convert it into a 16-byte integer.)

PS. The column must be defined as an INDEX and be UNIQUE.


Note, these are 2 separate steps