Viewing 5 posts - 1 through 5 (of 5 total)
Might be caused by parameter sniffing, http://www.sommarskog.se/query-plan-mysteries.html
May 29, 2014 at 8:46 am
Your solution reminded me of this SQL Spackle article from Jeff Moden.
February 24, 2014 at 3:19 pm
Jeff Moden (10/30/2013)
AronB (10/30/2013)
Thank you all for your solutions. It's greatly appreciated.The question now would be, do you understand how and why they work?
Yes, I do, but would be honored...
October 31, 2013 at 3:11 pm
Thank you all for your solutions. It's greatly appreciated.
October 30, 2013 at 11:17 am
I want to keep the existing rnk order, so that both rows 165935 are first and 100266 is second and so on. Your query doesn't do that.
1659351
1659351
1002662
.................
October 29, 2013 at 3:27 pm
Viewing 5 posts - 1 through 5 (of 5 total)