ColumnStore Indexes - Questions and Answers

Columnstore is a very exciting technology that can boost the performance of your queries by orders of magnitude. However, like every technology, you have to use it the right way in order to achieve such a performance boost.
We will start the session with a quick overview of the technology in order to bring everyone up to speed.
After that, we will start asking questions that will help us understand how to master it and be successful when working with it.
Among others, we will answer questions like:
• When will a Clustered Columnstore Index boost performance by orders of magnitude, and when it won’t help so much?
• How to defeat the “lazy” tuple mover?
• How to increase segment elimination?
• How to load data the right way?
• Why is "batch mode" so much faster than "row mode"?
• Is Nonclustered Columnstore still relevant?
We will also go over the new Columnstore features that will be included in SQL Server 2016 and emphasize the performance gains we can get from them.

[whymizan]

why you guys not carefull about sound system