Understanding SQL Server's DATETIME Data Type Limitations and Best Practices for SELECT MAX

Grouping Consecutive Rows with SQL Server 2008: A Efficient Approach Using Window Functions

Optimizing SQL Queries with Common Table Expressions (CTEs): A Guide to Removing Duplicate Rows