Get the deck
Thanks to Simon Sabin (blog | twitter) for his thoughtful feedback and suggestions.
Where to Start In Books Online
Using Date and Time Data: http://msdn.microsoft.com/en-us/library/ms180878.aspx<
Date and Time Functions: http://msdn.microsoft.com/en-us/library/ms186724.aspx
Row Compression Implementation (contains storage sizes) http://msdn.microsoft.com/en-us/library/cc280576.aspx
From here at LittleKendra.com…
Date Rounding Tactics and the Tiny Devil of SMALLDATETIME: http://www.littlekendra.com/2011/01/06/daterounding/
Filling in Data Potholes Redux: Tally Tables vs CTEs: http://www.littlekendra.com/2011/01/04/tallytables/
Helpful Blog Links
The ultimate guide to datetime datatypes (from 2004) by Tibor Karaszi http://www.karaszi.com/SQLServer/info_datetime.asp
Internal storage of Datetime2 and Datetime offset by Peter Larsson: http://weblogs.sqlteam.com/peterl/archive/2010/12/15/the-internal-storage-of-a-datetime2-value.aspx
Robyn Page’s DATETIME workbench: http://www.simple-talk.com/sql/learn-sql-server/robyn-pages-sql-server-datetime-workbench/
Craig Freedman’s Blog on Implicit Conversions: http://blogs.msdn.com/b/craigfr/archive/2008/06/05/implicit-conversions.aspx
PowerPivot(PRO) Date and DateTime- Sneaky Data Types! http://powerpivotpro.com/2011/02/21/date-and-datetime-sneaky-data-types/
The Query Optimizer and Date Correlation Optimization by Fabiano Amorim http://www.simple-talk.com/sql/t-sql-programming/the-query-optimizer-date-correlation-optimisation/
