SQL Server 2012: Nonclustered Columnstore Indexes [2013, ENG] torrent

Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Программирование (видеоуроки)

SQL Server 2012: Nonclustered Columnstore Indexes

Год выпуска: 2013
Производитель: Pluralsight
Сайт производителя: http://pluralsight.com/training/Courses/Description/sql-server-2012-nonclustered-columnstore-indexes
Автор: Joe Sack
Продолжительность: 1h 16m
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Описание: Узнайте, как некластеризованные индексы Columnstore в SQL Server 2012 могут ввести невероятные преимущества производительности при запросе очень больших наборов данных в реляционных хранилищах данных. Пименимо для разработчиков и администраторов баз данных, отвечающих за приложения яруса данных, начиная с SQL Server 2012

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

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.
[spoiler="Содержание"]
Course Introduction

Course Introduction
Course Structure

Nonclustered Columnstore Index Fundamentals

Module Introduction
Demo: Expanding the AdventureWorksDW2012 Database
Nonclustered Columnstore Indexes Defined
Demo: Nonclustered Columnstore Indexes - Hello World
Targeted Workloads and Environments
Non-ideal Candidates
B-Tree Row Storage
Just Accessing a Few Columns? It Doesn't Matter...
Columnar Data Storage
Segments
Demo: Segments
Row Groups
Syntax (1)
Syntax (2)
Demo: Syntax
This is NOT a B-Tree Index
Supported and Unsupported Data Types
How Performance is Achieved
Dictionary Encoding
Batch Execution Mode

Leveraging Batch-Execution Mode

Module Introduction
Traditional Row Execution Mode
Batch Execution Mode
Batch Mode Operator Support
Demo: Verifying Batch Execution Mode
Batch Execution Inibitors (1)
Demo: Serial Plan Batch Execution Inhibitor
Batch Execution Inhibitors (2)
Demo: NOT IN Batch Execution Inhibitor
Demo: Scalar Aggregate Batch Execution Inhibitor

Benefiting from Segment Elimination

Module Introduction
Segment Elimination (1)
Segment Elimination (2) and (3)
Demo: Segment Elimination

Managing Data Modifications

Module Introduction
Restricted Data Modifications
Demo: Restricted Data Modifications
Delta Table
Demo: Delta Table
Drop, Load, Create
Partition Switching
Demo: Partition Switching

Deployment Planning

Module Introduction
Interoperability Limitations
Index Creation Memory Requirements (1)
Index Creation Memory Requirements (2)
Demo: Index Creation Memory Requirements
Deployment Considerations (1)
Deployment Considerations (2)
vNext Clustered Columnstore Indexes
Course Summary
[/spoiler]
Файлы примеров: отсутствуют
Формат видео: WMV
Видео: wmv3, 1024x768, 15fps, 72~2441 kbps
Аудио: wma2, 44.1kHz, 128kbps, Stereo
[spoiler="Скриншоты"]

[/spoiler]
Доп. информация: Exercise Files includes presentation slides plus code files.