• mister.magoo (4/30/2014)


    Or I have a crappy 2012 install?

    Few weeks back, before upgrading the 2012 system I´m working on to 2014, I ran into a similar behavior when forgetting the filter/limit on the numbers cte. Adding the filter corrected the problem then.

    Was the changes in the cardinality estimator or guesstimator? Seeing estimated 10 rows, actual rowcount 10000000 rows in the exec plan.;-)

    Changing to 110 compatibility halves the execution time.