SQL Server - Use Updatable Tables for Responsive Real-Time Reporting
Wed, 01 Oct 2014 10:00:00 GMT
Managing massive data stores in a single table can slow down queries and, therefore, business activities. Using a combination of partitioning and columnstore indexes solves the problem.
SQL Server - Implement Large, Fast, Updatable Tables for Responsive Real-Time Reporting
Wed, 01 Oct 2014 10:00:00 GMT
This article builds on the October MSDN Magazine print article, “Use Updatable Tables for Responsive Real-Time Reporting,” that describes a combination of table partitioning and columnstore indexing to support a large table you can query rapidly for reporting and update concurrently.