title: SQL Server DateTime2(0) vs Date
body: <p>What are the implications of using SQL Server's DateTime2 with a precision of 0 to represent a date rather than the built in Date field. </p>
  
  <p>In either case, my concern is to prevent accidental time entries, but are there storage or performance considerations I should take note of?</p>