I happened upon this article, which summarizes the datetime datatype and how it works in SQL Server, including common pitfalls and general recommendations.

The site is run by Tibor Karaszi a fellow Solid Quality Learning mentor.