title: MSSQL index between two dates
body: <p>I have a table that consist of many columns, among them two dates (startDate and endDate).</p>
  
  <p>The table contains 15.000.000 records.</p>
  
  <p>My query is is setup like this</p>
  
  <pre><code>SELECT ID FROM table WHERE @inputdate BETWEEN startDate and endDate
  </code></pre>
  
  <p>How should my index be setup to maximize performance?</p>