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.
http://www.pluralsight.com/training/Courses/Description/sql-server-2012-nonclustered-columnstore-indexes
Download File Size:172.3 MB