title: CAST(DATETIME AS DATE) over WHERE clause
body: <p>I'm using SQL Server 2012 and I would like to know if I write the sentence: </p>
  
  <pre><code>SELECT MyDateTimeColumn 
  FROM MyTable
  WHERE CAST(MyDateTimeColumn AS DATE) = '2014-07-09'
  </code></pre>
  
  <p>is a slower way to trim the time over DATETIME columns, I have searched but I can't find anything about this strict sentence and I don't know how to show that impresive statistics about time consuming cast/convert to probe it myself.</p>