How do I troubleshoot the cardinality estimator differences from 2012 to 2014?

I am trying to get the query to execute much faster on SS 2014 like it does using the 2012 CE. The query plans are virtually identical so I'm not sure where to start looking for problems. The only hint I see is that there are writes on 2014 and not on 2012. Where should I begin investigating?

Thanks, Tony

avatar image By Tony Green 37 asked Feb 14 at 09:02 PM
more ▼
(comments are locked)
10|10000 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.

Follow this question

Topics:

x611
x427
x3
x2
x1

asked: Feb 14 at 09:02 PM

Seen: 22 times

Last Updated: Feb 14 at 09:02 PM