Thanks Gail.

I signed up to Dev Essentials and downloaded DEV some while ago, and the discussion has been ongoing since.

We have a handful of Developers, and the...

Thanks for the response Kevin.

My take was that the SSDs are what they are - whether they are locally or network attached in our environment it would be...

Hello Gail.

Thanks for the response - looking for a quick fix as this is affecting productivity - the sub-query is just doing a count on the table for...

Got there in the end - back to Plan A - that I couldn't get to work in the beginning.
I had to create a Template Plan Guide to Force parameterisation

Thanks Grant!

You are quite correct and if I create an unparameterized plan guide that exactly matches the select, with a hardcoded integer,
and execute the select, it...

Thanks Grant.

I had read that on many posts (some by yourself IIRC)  and as a result I copy the select from the XML or the plan guide into...

Thanks Folks - the learning process continues.

"Or, as Kevin already pointed out, a query plan gets a row estimate that is wildly off, decides it needs to allocate...

That is odd - I had to look to make sure that I didn't post this as I started to post similar ,earlier in the week.

I actually posted something related...