>>> >>>This is a bad query as it doesn't use index on the dropDate if it exists. >>> >> >>Naomi, instead of saying "this is a bad query", why don't you ask him to show the execution plan and then you can explain specifically why it won't perform optimally. > >Actually, I like Aaron's Bertrand blog on this topic which is old but good: > w>http://sqlblog.com/blogs/aaron_bertrand/archive/2009/10/16/bad-habits-to-kick-mishandling-date-range-queries.aspx