- ROLAP with Column Store – Deep Dive
Description:
The Column Store Index is an exciting new technology in SQL Server 2012. Using column stores, you can unlock new levels of performance for data warehouses - often gaining an order of magnitude speedup on queries. In this session, we will talk about the design patterns you must apply to take advantage of this functionality.
We will use a real, high end customer solution as a case study. As we dig deep into the workload, we will show you examples of Column Store DW query plans and walk you through the design decisions we made along the way. The ride will not be smooth, but we hope you will learn from the challenges we faced, and the methods we used to overcome them.
As bonus feature, we will also look at how column stores in ROLAP cubes compare with MOLAP cubes.
Go to top