title: Offload data from SQL database
body: <p>I have Azure SQL database which stores ~1 million rows per week in a single table (time series data). It has become hard to manage the data due to it's size. I have to rebuild indexes daily to be able to execute queries in less than a second.</p>
  
  <p>I am looking for a way to offload most of the data away from active table/database. For daily operations my application needs only last 2 millions of rows. However, I still need all of the data for historical analysis, so deleting it is not an option.</p>
  
  <p>What would be the best way to deal with it? Most desirable option would be use of some (inexpensive) Azure service, storage. I was considering writing a script that would automatically move data to another database/table but that is really last option. I would rather use a service that was made for this exact purpose, if there exists one.</p>