I very much enjoyed the article. I sent it on to our team because we've had this debate internally several times.

That said, a few bones to pick...

It is a bit...

Great topic.

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...