SQLBits 2015

Understanding & Solving Columnstore Problems

Dive deep into Columnstore Indexes and discover their advantages and some of the limitations. Look into some of the Columnstore Indexes myths, understand more complex concepts of Batch Mode & Query Processing with another depth.
Dive deep into Columnstore Indexes and discover their advantages and some of the limitations.
Look into some of the Columnstore Indexes myths, understand more complex concepts of Batch Mode & Query Processing with another depth.

Can you make your Columnstore queries ran even faster ?
Can you actually lower the Degree of Parallelism and get a better performance ?
How much memory does Columnstore Index actually use when working with queries ?
How can you test your Columnstore queries in Row Mode and what is the actual difference between Row & Batch Modes.

The answers on those questions are to be revealed at this session.