Eirikur Eiriksson (10/4/2015)
erb2000 (10/4/2015)
Yes, it is a huge IN clause with hundreds of elements.Quick suggestion, have a look at this article When is a Seek not a Seek? by Paul White, sounds like this is your problem.
😎
As a fix you could try to change the IN clause to a table.
Yes, we will be fixing the product, but it is going to take some time.
The compatibility level is 100. We don't understand why upgrading from 2008 to 2014 caused this problem. We're looking for a quick fix, short of going back to 2008.