If you're considering using uniqueidentifiers on your tables, particularly as primary keys, then you might want to upgrade your SQL Server or just check your SQL carefully if you're still running SQL Server 2000.
In particular, doing a COUNT(field) on…
more »