>I'll agree. I tend to stay in the world of INTEGERs (including BIGINT). Hands down, this is the fastest. There's a use for GUIDs, especially if the data is distributed.
>
>-Mike

Espesially since SQL Server 2000 has the new indentity variables so that triggers inserting into triggers won't affect things. Although, I don't favor int due to speed, I favor it because it is much easier for me to type...

select * from master where id = 234

than

select * from master where id = {12134-123j4hk-1324hkjh-alk}

BOb