Dating Responsibly

This is a collection of resources involving date/datetime handling in SQL Server. Or, "why is Aaron telling me to use or avoid <x>?"

BETWEEN

Regional formats

Shorthand

Trimming time and other calculations

Calendar table

Best Practices