I have a large table with a primary key (GUID) that is also the clustered index. There is already a integer sequence based field. So I want to leave the GUID as the PK and make the integer column the clustered index.
I can't figure any way to do this except drop the original constraint and create new PK and and new clustered index. But this takes a long time and from what I gather, rebuilds the table twice, once to go from clustered index to heap, and then heap back to clustered index.
I can't do a table rebuild (create new, migrate data, swap names) since I can't have an outage.
Version: SQL Server 2008 Service Pack 2, Developer/Enterprise.