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

Tony Green 2017-02-14 21:02:20

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?