Thursday 10th September, 2015
8:30am to 5:30pm
Make sure you spend the whole day learning about the most important technology Microsoft has launched since the beginning of SQL Server – Columnstore Indexes. We will investigate how you can optimise your BI & DataWarehousing solutions and take the advantage of the modern Columnstore Architecture significantly boosting your query performance and analytics reporting.
Learn how to get the very best out of your existing database environments and how you can monitor, optimise, implement and solve many Columnstore Indexing problems.
Discover how to take the full advantage of the Batch Processing mode for Columnstore Indexes, which can significantly accelerate your query processing by hundreds of times, and learn about its limits.
Through the use of Dynamic Management Views, Extended Events and Traceflags we shall analyse traditional Rowstore tables and turn them into highly-performing modern Columnstore tables that will provide the best query performance possible with the current technology on offer. Using different advanced optimisation techniques we shall boost the performance of Columnstore Indexes further by clustering them into adaptive structures using better Segment Partitioning and lowering their memory requirements.
During the full day workshop we shall consider many different scenarios such as :
When Columnstore Indexes should be applied on Fact tables.
When Columnstore Indexes can be applied on the Dimension tables.
Which conditions we can apply Clustered Columnstore Indexes even for the OLTP scenarios.
When not to use Columnstore Indexes.
Design Patterns for the Columnstore Indexes tuning.
If you are serious about SQL Server query performance and want to learn when, how and why you should utilise this exiting new technology then this session is for you!
Data Platform, Community, Columnstore, CISL, All Things Data, Tuga Association Leader. Blah, Blah ... bio from Twitter
Sign in to add slides, notes or videos to this session