SQL Server 2012: Nonclustered Columnstore Indexes
Pluralsight
Course Summary
Learn how nonclustered columnstore indexes in SQL Server 2012 can introduce incredible performance benefits when querying very large data sets in relational data warehouses, applicable to developers and DBAs responsible for application data tiers, from SQL Server 2012 onwards
-
+
Course Description
If you need to develop a solution to meet your business intelligence needs but don't have the in-house SQL Server Analysis Services skills to make it happen, don't rule out a SQL Server database engine solution just yet. SQL Server 2012 nonclustered columnstore indexes provide a compelling new option for extremely fast querying of very large data sets found in relational data warehouses. This course will cover the benefits of this new functionality and will also clearly articulate the current limitations and planning considerations along the way. By the end of this course, you'll be equipped with enough information to help decide if nonclustered columnstore indexes will be a viable choice for your application data tier. This course is perfect for developers, DBAs, and anyone responsible for SQL Server performance. The information in the course applies to SQL Server 2012 onwards.
-
+
Course Syllabus
Course Introduction- 2m 2s
—Course Introduction 0m 51s
—Course Structure 1m 11sNonclustered Columnstore Index Fundamentals- 30m 22s
—Module Introduction 1m 6s
—Demo: Expanding the AdventureWorksDW2012 Database 3m 45s
—Nonclustered Columnstore Indexes Defined 0m 51s
—Demo: Nonclustered Columnstore Indexes - Hello World 4m 33s
—Targeted Workloads and Environments 1m 50s
—Non-ideal Candidates 1m 31s
—B-Tree Row Storage 0m 17s
—Just Accessing a Few Columns? It Doesn't Matter... 0m 22s
—Columnar Data Storage 0m 24s
—Segments 0m 24s
—Demo: Segments 4m 32s
—Row Groups 0m 39s
—Syntax (1) 0m 55s
—Syntax (2) 0m 42s
—Demo: Syntax 2m 26s
—This is NOT a B-Tree Index 1m 50s
—Supported and Unsupported Data Types 0m 55s
—How Performance is Achieved 1m 47s
—Dictionary Encoding 0m 44s
—Batch Execution Mode 0m 49sLeveraging Batch-Execution Mode- 15m 8sBenefiting from Segment Elimination- 6m 4sManaging Data Modifications- 11m 1sDeployment Planning- 11m 31s
