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. 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.

Speaker

Alexei has been with Microsoft since 10+ years. He has started with SQL Server collecting globalization requirements from European countries during the version SQL Server 2005 development. Since about 2 years a member of European part of the SQL Customer Advisory team. He is focusing on large scale Data Warehouses such as well-known European Telecommunication Organizations, on architecture principles which are well reflected in the Fast Track reference Architecture guide. Has published articles on different database topics. Alexei has graduated from Moscow Engineering Physics Institute

Alexei Khalyako's Sessions