SQLBits 2012

ROLAP with Column Store - Deep Dive

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.


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.