title: Improve Efficiency of 'Transactions Last Hour' (or 'Date Between') Query
body: <p>Found that queries to this very large table (~100 million records) are inefficient (often 20-30 seconds but can be more), but not sure what to do about it:</p>
  
  <pre><code>SELECT @TRXCOUNT = count(1)
  FROM inbound.[Transaction] WITH (NOLOCK)
  WHERE CreatedTimeStamp BETWEEN DATEADD(HH, - 1, SYSDATETIME()) AND SYSDATETIME()
  </code></pre>
  
  <p>The execution plan shows Index Scan (NonClustered) Cost 93%</p>