ALTERTABLE [dbo].[Transactions] ADDCONSTRAINT [DF_Transactions_GUID] DEFAULT (newid()) FOR [GUID]
>>> >>>thanks, I'll read the blog. >> >>With NEWID() as default you definitely do not want to have it clustered. > >I should be able to change the default to newsequentialid(), but I think what happened here is that I was generating lots of records relying on the default, but the code actually uses .NET to generate the Guid and not rely on the default. I wonder if there is a newsequentialid for c#.... :)
There is no newsequentialid in C# but I think I read about some implementations. Check this blog post