Cardinality Estimator
Here is a good reference to look at when having problems with cardinality estimation. You can also see differences between SQL Server 2012 and 2014 and usage scenarios of various trace flags. Also, finally
Here is a good reference to look at when having problems with cardinality estimation. You can also see differences between SQL Server 2012 and 2014 and usage scenarios of various trace flags. Also, finally