Have you seen this in Yukon Beta 2? NewSequentialId() joins the fray
There is a new command in Yukon Beta 2 for generating GUIDs / uniqueidentifiers. It is the NewSequentialId() method. I don't know if it will eliminate the potential performance problems I have seen when using uniqueidentifiers, but it is there. I don't know if it will make it to the final released version.
SELECT
NEWSEQUENTIALID()UNION ALL
SELECT NEWSEQUENTIALID()
UNION ALL
SELECT NEWSEQUENTIALID()
results in this output:
4d6e4dbb-8706-d911-afcb-000f1f1b2c2a
4e6e4dbb-8706-d911-afcb-000f1f1b2c2a
4f6e4dbb-8706-d911-afcb-000f1f1b2c2a
I can't even take credit for this. Jimmy Nilsson mentioned it on his blog yesterday and I just ran across it.