• One of the big changes that was made in SQL Server 2014 was that the cardinality estimator was significantly changed. This resulted in behavior changes, both good and bad.

    Tom LaRock has written extensively on the changes in the CE and how to work with them. You can check out his blog here and here.