>>>What is the default value for the column? Check this blog post
>>>
>>>
http://blogs.lessthandot.com/index.php/datamgmt/dbprogramming/best-practice-don-t-not-cluster-on-uniqu/>>
>>
ALTER TABLE [dbo].[Transactions] ADD CONSTRAINT [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#.... :)