Reece Goding
Reece Goding
@erikdarlingdata There is a lot in the Query Store documentation about trying to find if you have an ad-hoc workload, but I don't think that Query Store is the right...
@erikdarlingdata I've taken your advice. These are my observations from an instance with a lot of non-parameterised queries: - Grouping by `query_id` is useless for detecting lack of parameterisation. "Identical"...
It's funny what you find once you group by `query_hash`. I have one with 7 `plan_id`s, 4 `query_plan_hash`es, and 2 `query_id`s. It's hard to tell which of those numbers is...
Got super close to getting it working in [this branch](https://github.com/ReeceGoding/DarlingData/blob/QuickieStorePlanHashes/sp_QuickieStore/sp_QuickieStore.sql). I think that I've forgotten to break ties by query hash when several queries have the same number of plan...
@erikdarlingdata I'm having a look at the wait stats part of this. Do you still have plans for the documentation of `sp_QuickieStore`? I recall you saying at some point that...
@erikdarlingdata No. The recent merge made a tiny dent in it while documenting the regression stuff, but it didn't touch the vast majority of the stuff here.
@dfinke I've made an edit. Is that better?
> try again with the newest version and report back pls 🙏🏼 Couldn't get it to work on 2.5.1 on Linux. Will try Windows soon.
@potatoqualitee Same result on Windows as in the original post. My version is 2.5.1.
@andreasjordan I'm not sure if you're asking my to test a particular cmdlet, but I think it's safe to assume from the above that it won't work.