Optimising date filtered SQL queries

How you structure your SQL queries is very important and choosing the wrong approach can have big effects on the performance of the query. This article shows the difference between an optimal query and a sub-optimal query resulting from subtle changes to the approach taken.