QL Server 2008 introduced new data types to handle dates and times in a more intelligent way than the previous
SMALLDATETIMEtypes that we looked at previously.
The first one we look at this week is
DATETIMEuses eight bytes and
SMALLDATETIMEuses four bytes to store their values,
DATEonly needs a slender three bytes to store any date value between
DATE data type was a fantastic addition to SQL Server 2008.