Home Forums SQL Server 2008 T-SQL (SS2K8) Need help to filter based on From (Month and Year) and To (Month and Year) RE: Need help to filter based on From (Month and Year) and To (Month and Year)
Eirikur Eiriksson
SSC Guru
Points: 182882
More actions
December 7, 2014 at 2:00 pm
#1763177
BTW the 2014 cardinality estimator goes on a hike on this one, with only handful of rows in the set it estimates 16.4317 rows for both queries, in fact the optimizer produces exactly the same plan for both.
😎