What You Need to Know Before
You Start
Starts 13 June 2025 12:21
Ends 13 June 2025
SQL Server 2012: Nonclustered Columnstore Indexes
659 Courses
Not Specified
Optional upgrade avallable
All Levels
Progress at your own speed
Free
Optional upgrade avallable
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.
Taught by
Joe Sack
Subjects
