title: MS SQL Delete records older than month
body: <p>I have data stored in ms sql database. I want delete all records older than some date. 
  For this, a service is used that sends a request once a day, like:</p>
  
  <p><code>delete from [log].[HttpRequestLogEntries] where DateTimeUtc &lt; dateadd(day, -3, getutcdate())</code></p>
  
  <p>and it work fine, but very slowly. In my table can be over 10kk rows and deleting may take hours for the work.
  How to solve this problem in the best way?</p>