Changing newid() to newsequentialid() on an existing table
Posted
by cbp
on Stack Overflow
See other posts from Stack Overflow
or by cbp
Published on 2009-05-27T01:22:07Z
Indexed on
2010/06/06
20:12 UTC
Read the original article
Hit count: 180
Hi, At the moment we have a number of tables that are using newid() on the primary key. This is causing large amounts of fragmentation. So I would like to change the column to use newsequentialid() instead.
I imagine that the existing data will remain quite fragmented but the new data will be less fragmented. This would imply that I should perhaps wait some time before changing the PK index from non-clustered to clustered.
My question is, does anyone have experience doing this? Is there anything I have overlooked that I should be careful of?
© Stack Overflow or respective owner