>
>The ever increasing identity column is the best candidate for the clustered PK. You made a right switch, by default SQL Server makes PK column clustered. Perhaps you originally somehow made it non-clustered.
Just to clarify - if you create an identity column and make it a primary key, SQL Server (by default) will make it a clustered index.
But simply making a column an identity column (without giving the PK designation) doesn't make it a clustered index (actually no index is created)