zouzou (12/13/2016)
Hello all,The same query with a group by clause I try to run on SQL Server 2005 and on SQl Server 2014 but it seems that every time i run the same thing on SQL server 2014 gives me a different output different results when i press F5. In SQL server 2005 its consistent with the results
Any ideas why this it ?
thank you so much in advance
Does the query have an order by clause? Given that the data is the same, if it doesn't have an order by clause, then the difference would most likely be the new cardinality estimator choosing a different plan than the earlier versions and since no order for the output is set then the results will be "in order of appearance"
😎
Can you post the actual execution plans for those queries?