title: SQL server Table partition with history data
body: <p>I have a table in SQL SERVER 2008 R2 db with 110 mill rows.To improve the performance of canned report, I am suggesting to partition the table. However the user query fetches inception to date data in all their runs.</p>
  
  <p>Which means partition with date/month will not be helpful if there is no specific date range for data select.</p>
  
  <p>Can you please suggest how I can implement the partition to gain performance.</p>
  
  <p>Thanks.</p>