SQL Server 2012: Nonclustered Columnstore Indexes

via Pluralsight

Overview

Learn how nonclustered columnstore indexes in SQL Server 2012 can introduce incredible performance benefits when querying very large data sets in relational data warehouses. This course is ideal for developers and DBAs responsible for application data tiers from SQL Server 2012 onwards.

If you need to develop a solution to meet your business intelligence needs but lack the in-house SQL Server Analysis Services skills, don’t rule out a SQL Server database engine solution just yet. SQL Server 2012 nonclustered columnstore indexes offer a compelling new option for extremely fast querying of large data sets found in relational data warehouses.

This course will cover the benefits of this new functionality and clearly articulate the current limitations and planning considerations. By the end of this course, you'll have enough information to decide if nonclustered columnstore indexes are a viable choice for your application data tier.

This course, provided by Pluralsight, is perfect for developers, DBAs, and anyone responsible for SQL Server performance. The information applies to SQL Server 2012 and beyond.