If you have a large reporting data and have not explored the new Columnstore Indexes. Take some time to review what you are missing. Unlike regular database indexes (rowstore format) that index tables based on the data tied to a row. Columnstore indexes compress the data within a column to quickly index common fields such as dimension keys within a fact table. Resulting in much faster query processing times by compressing data within a column. For instance, running an aggregate query on product sales on a fact table with a million rows for the current year. Allows the query to select only those columns that it needs to fetch the results, instead of all of the rows.