Database and Analytics

TH03 SQL 2014 Columnstore Indexes and In-Memory Optimized Tables

06/04/2015

8:00am - 9:15am

Level: Introductory to Intermediate

Kevin Goff

Kevin Goff

Microsoft SQL Server MVP

Practice Manager

SetFocus, LLC

SQL Server 2014 Enterprise contains two powerful features that can significantly enhancement performance in Data Warehousing systems: the Columnstore index and In-Memory optimized tables. In this presentation, I'll cover these 2 features, their benefits and limitations as I walk through an actual Data warehouse implementation. We'll also look at some common patterns in the Kimball Data Warehouse methodology (slowly changing dimensions, fact table loading, etc.) and how to implement them. If you are looking to start a data warehouse project with SQL Server 2014 Enterprise, this session is for you!

You will learn:

  • How Columnstore indexes can provide significant performance gains
  • How In-Memory optimized tables can provide significant performance gains
  • Common Data Warehouse patterns and how to implement them using SQL Server