title: DateTime2 vs DateTime in SQL Server
body: <p>Which one: </p>
  
  <ul>
  <li><a href="https://msdn.microsoft.com/en-us/library/ms187819.aspx" rel="noreferrer"><code>datetime</code></a></li>
  <li><a href="https://msdn.microsoft.com/en-us/library/bb677335.aspx" rel="noreferrer"><code>datetime2</code></a></li>
  </ul>
  
  <p>is <em>the</em> recommended way to store date and time in SQL Server 2008+?</p>
  
  <p>I'm aware of differences in precision (and storage space probably), but ignoring those for now, is there a best practice document on when to use what, or maybe we should just use <code>datetime2</code> only?</p>