"Without human intervention" - No, even its technically possible to an extend for some tables, you may avoid.
PK and clustered are tow different and important things in SQL Server. So evaluate your business and table structure and its usage (query + column) and then decide. It may take some times to understand the business and come up with a plan, but thats important and inevitable.
Please mark this reply as answer if it solved your issue or vote as helpful if it helped.
[Blog]
No comments:
Post a Comment