Another cool feature in SQL Server 2005 is the DATE_CORRELATION_OPTIMIZATION option. This feature is off by default, but can improve query performance. It is necessary for the two datetime columns to involved in the equi-join between tables and also be used in the predicate. This tip I discovered in reading "SQL Server 20005: Changing the Paradigm". Check it out!