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.
Remember Me
Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.