>Btw, just occurred to me to ask. Is the syntax of using >= and < (as in your example) faster than using Between?
>

It is not faster, but this is the correct syntax when dealing with dates if you want to include time portion for the second date.

Take a look at these two links

The ultimate guide to the datetime datatypes
Bad habits to kick : mis-handling date / range queries