• Matt, I completely agree with most of your points, but are you sure about the last one?

    Heaps don't have page splits.

    An update of a VARCHAR column in a table with no clustered index cannot cause a page split in the data pages? I think it can.

    Sorry if I'm splitting pages (... I mean hairs 🙂 ), but I want to make sure my understanding is correct here.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]