Adam Machanic : T-SQL, datehttp://www2.sqlblog.com/blogs/adam_machanic/archive/tags/T-SQL/date/default.aspxTags: T-SQL, dateenCommunityServer 2.1 SP2 (Build: 61129.1)What Happened Today? DATE and Date Ranges Over DATETIMEhttp://www2.sqlblog.com/blogs/adam_machanic/archive/2009/10/20/what-happened-today-date-and-date-ranges-over-datetime.aspxTue, 20 Oct 2009 18:21:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:18023Adam Machanic14http://www2.sqlblog.com/blogs/adam_machanic/comments/18023.aspxhttp://www2.sqlblog.com/blogs/adam_machanic/commentrss.aspx?PostID=18023A few days ago Aaron posted yet another fantastic entry in his Bad Habits series, this one discussing mishandling of date ranges in queries . This is a topic near and dear to me, having had to clean up a lot of poorly thought out code in the past few...(<a href="http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/10/20/what-happened-today-date-and-date-ranges-over-datetime.aspx">read more</a>)<img src="http://www2.sqlblog.com/aggbug.aspx?PostID=18023" width="1" height="1">datedatetimeOptimizationPerformanceT-SQL