sp_BlitzIndex - new check_id 128 - Heaps with PAGE compression

[VladDBA]

Is your feature request related to a problem? Please describe.

Some folks slap PAGE compression on active heaps without reading the documentation, unaware that new records will only be row compressed unless the inserts are handled in a specific way or the heap undergoes a rebuild after new data is added.

Describe the solution you'd like

sp_BlitzIndex ran with @Mode=0 or @Mode=4 should also return information about page-compressed heaps.

Column	Value
Priority	100
Finding	Indexes Worth Reviewing: Heap with PAGE compression
Details	Should this table be a heap? schema_name.heap_name.Unknown (0)
URL	https://vladdba.com/PageCompressedHeaps

Describe alternatives you've considered

Hoping that people read the docs before randomly pushing buttons.

Are you ready to build the code for the feature?

Yup, PR incoming.