robert.nesta123 (1/9/2013)
Changing NON CL PK to Clustered can have a negative impact?
Oh yes, especially if the PK column is not a good one for a clustered index.
If so what is the best course of action for these heaps.
Create a clustered index on a column or set of columns that are a good choice for a clustered index. That may be the PK. It may not. It requires analysis, investigation and thorough testing
Testing this is not really an option.
Then you don't make any changes. If you're not going to test, leave the DB alone, you'll do the least harm that way.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability