title: Best way to check for current date in where clause of sql query
body: <p>I'm trying to find out the most efficient (best performance) way to check date field for current date.  Currently we are using:</p>
  
  <pre><code>SELECT     COUNT(Job) AS Jobs
  FROM         dbo.Job
  WHERE     (Received BETWEEN DATEADD(d, DATEDIFF(d, 0, GETDATE()), 0)
                          AND DATEADD(d, DATEDIFF(d, 0, GETDATE()), 1))
  </code></pre>