I am working on a legacy database. The primary key is clustered varchar(128) and the table contains a high volume of data.
Does it necessarily help performance if I change the clustered PK to nonclustered?
Changing the table to a heap would at least it prevent more data fragmentation after inserting any new rows (to the best of my knowledge - I am not a DBA). I also have similar problem with uniqueidentifier primary keys here.