sp_BlitzIndex: sort the list of temporal tables in mode 4 #3727
Description
Is your feature request related to a problem? Please describe.
CheckId 110 of sp_BlitzIndex helpfully lists out all of your temporal tables and their history tables. However, the list isn't sorted in any clear order. If you have a database with lots of temporal tables, it's unreadable. Ideally, I would like to see it sorted by the database, schema, and table name of the temporal table.
Describe the solution you'd like
Ideally, we could solve this problem for most checks by adding br.index_definition to the end of the ORDER BY in the final output and then making sure that any checks that look better sorted bother to populate that column. Right now, I would only try to solve that for temporal tables.
Describe alternatives you've considered
Put an ORDER BY in CheckId 110's code and hope the sort order survives.
Are you ready to build the code for the feature?
As much as we'd love to build everything that everyone wants for free, we need your help. Open source is built with your help and code. Are you ready to commit time to this project? Have you got existing code you can help contribute to solve the problem?
I've convinced myself that it will only take a few lines so you will probably see the PR tonight.