sm_iransoftware (1/30/2015)
Because I read somewhere , PK and Clustered index, can be separate (These two do not necessarily Be one thing)
They can be, yes.
And it's better that clustered index related to Bussiness and on a benefit field that use in queries.
Maybe, maybe not. Depends on queries, tables and a whole lot more. Changing a clustered index requires a huge amount of testing first. It's not something you do without analysis and testing first.
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