Tips for using data types in SQL Server 2014 Use Date/Time data types to store date/time information separately. In SQL Server 2014 you can store the date and time information separately. For example, if you need to work with date data only, use the Date data type instead of datetime or smalldatetime to optimize storage space and simplify date modifications…