In my current database almost all tables have primary key GUID. The performance is horrible. I want to go with sequential GUID. I test it and it looks fine. Only problem is what to do with existing GUID. I need to make it work together. I changed primary key field to default NEWSEQUENTIALID() and after insert new GUID was first in order because NEWSEQUENTIALID() Creates a GUID that is greater than any GUID previously generated by this function. Is there any way to append new sequential GUID to existing ones on sequential order? For example, if we want to convert numeric id to sequential order we can find maximum current value, change field to identity and start with seed value bigger then that. Can we do something like that with GUID?
Mk