SQL Server 2012: Nonclustered Columnstore Indexes
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
What you'll learn
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.
Table of contents
- Module Introduction 1m
- Demo: Expanding the AdventureWorksDW2012 Database 4m
- Nonclustered Columnstore Indexes Defined 1m
- Demo: Nonclustered Columnstore Indexes - Hello World 5m
- Targeted Workloads and Environments 2m
- Non-ideal Candidates 2m
- B-Tree Row Storage 0m
- Just Accessing a Few Columns? It Doesn't Matter... 0m
- Columnar Data Storage 0m
- Segments 0m
- Demo: Segments 5m
- Row Groups 1m
- Syntax (1) 1m
- Syntax (2) 1m
- Demo: Syntax 2m
- This is NOT a B-Tree Index 2m
- Supported and Unsupported Data Types 1m
- How Performance is Achieved 2m
- Dictionary Encoding 1m
- Batch Execution Mode 1m
- Module Introduction 1m
- Traditional Row Execution Mode 1m
- Batch Execution Mode 1m
- Batch Mode Operator Support 1m
- Demo: Verifying Batch Execution Mode 3m
- Batch Execution Inibitors (1) 1m
- Demo: Serial Plan Batch Execution Inhibitor 2m
- Batch Execution Inhibitors (2) 1m
- Demo: NOT IN Batch Execution Inhibitor 3m
- Demo: Scalar Aggregate Batch Execution Inhibitor 2m
- Module Introduction 1m
- Interoperability Limitations 1m
- Index Creation Memory Requirements (1) 1m
- Index Creation Memory Requirements (2) 1m
- Demo: Index Creation Memory Requirements 3m
- Deployment Considerations (1) 2m
- Deployment Considerations (2) 1m
- vNext Clustered Columnstore Indexes 1m
- Course Summary 1m