I look forward to seeing the details of how you implement your changes. We've been working with a change management process, that takes into account the issues you raised,...
One reason, indexes on heap tables are forced to use the physical storage location of the data. Any page splits in the data itself will cause a cascade to any...