title: get records from yesterday from log table
body: <p>Scenario:</p>
  
  <p>log table with a considerable amount of records (2 Million) with a timestamp field.
  no indexes except for the ID as a primary key, and index (or any other persistent object) creation is out of the question</p>
  
  <p>I want to select all records from yesterday.</p>
  
  <p>I know there are a few ways of doing it, I just would like opinion on the "best" way, and by best I mean fastest.</p>
  
  <p>the trick here is the "time" of the timestamp, because if now is 11AM and I do something like:</p>
  
  <pre><code>where modifiedDate between dateadd(dd,-1,getdate()) and getdate()
  </code></pre>
  
  <p>Ill get records only from yesterday at 11 and will get data from today</p>
  
  <p>Its sql 2005 so there is no "Date" datatype</p>