Skip to content

sp_QuickieStore: Put the columns from the sort-helping tables somewhere less hidden #603

@ReeceGoding

Description

@ReeceGoding

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

EXEC sp_QuickieStore
  @hide_help_table = 1,
  @get_all_databases = 1,
  @sort_order = 'total waits';

and try to find where the column that you're sorting by is. It's too hard!

Describe the solution you'd like
If a sort order requires a new column to be bolted on, then we should put that new column somewhere that is hard to miss. For example, total_wait_time_from_sort_order_ms should be just before avg_duration_ms.

Describe alternatives you've considered
I'm tempted to just move the waits one, but that's probably laziness.

Are you ready to build the code for the feature?
Yeah. This is kind of my fault, after all. And if I had Git configured correctly, then you would easily be able to search my GitHub history for this repo and find it. I should fix that at some later point.

IMPORTANT: If you're going to contribute code, please read the contributing guide first.
https://github.com/erikdarlingdata/DarlingData/blob/main/CONTRIBUTING.md
Again?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions