Viewing 12 posts - 61 through 72 (of 72 total)
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...
July 24, 2017 at 5:18 am
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...
July 24, 2017 at 5:14 am
June 2, 2017 at 6:37 am
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...
June 2, 2017 at 3:49 am
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
April 1, 2017 at 8:24 am
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...
April 1, 2017 at 3:31 am
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...
March 31, 2017 at 9:50 am
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...
February 27, 2017 at 2:45 am
January 24, 2017 at 3:40 pm
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...
December 23, 2016 at 8:22 am
Viewing 12 posts - 61 through 72 (of 72 total)