SQL Between Operator and (GTE and LTE)
Performance Benchmarking. http://www.sqlservercentral.com/blogs/technobabble-by-klee-from-kleegeek/2013/03/29/is-between-faster-than-gte-and-lte/ And a different result for Date/Time, it is a pitfall and worth to look and change your sql if you wanna accurate. http://sqlblog.com/blogs/aaron_bertrand/archive/2011/10/19/what-do-between-and-the-devil-have-in-common.aspx