SQL Server 2012 Nonclustered Columnstore Indexes | 213D6C56293DDCF347DF9C78E599B5A3407B3A01

SQL Server 2012 Nonclustered Columnstore Indexes

Name	SQL Server 2012 - Nonclustered Columnstore Indexes	DOWNLOAD Copy Link
Total Size	193.1 MB
Total Files	64
Hash	213D6C56293DDCF347DF9C78E599B5A3407B3A01

/02. Nonclustered Columnstore Index Fundamentals/
04. Demo Nonclustered Columnstore Indexes - Hello World.wmv	19.8 MB
11. Demo Segments.wmv	16.2 MB
02. Demo Expanding the AdventureWorksDW2012 Database.wmv	8.9 MB
15. Demo Syntax.wmv	5.2 MB
05. Targeted Workloads and Environments.wmv	2.6 MB
16. This is NOT a B-Tree Index.wmv	2.6 MB
18. How Performance is Achieved.wmv	2.5 MB
06. Non-ideal Candidates.wmv	2.1 MB
01. Module Introduction.wmv	1.7 MB
17. Supported and Unsupported Data Types.wmv	1.5 MB
13. Syntax (1).wmv	1.3 MB
03. Nonclustered Columnstore Indexes Defined.wmv	1.2 MB
20. Batch Execution Mode.wmv	1.2 MB
19. Dictionary Encoding.wmv	1.1 MB
12. Row Groups.wmv	977.3 KB
14. Syntax (2).wmv	974.3 KB
08. Just Accessing a Few Columns It Doesn't Matter.wmv	736.9 KB
10. Segments.wmv	694.8 KB
09. Columnar Data Storage.wmv	688.8 KB
07. B-Tree Row Storage.wmv	457.5 KB
/04. Benefiting from Segment Elimination/
04. Demo Segment Elimination.wmv	17.9 MB
03. Segment Elimination (2) and (3).wmv	1.5 MB
01. Module Introduction.wmv	1.3 MB
02. Segment Elimination (1).wmv	1.2 MB
/05. Managing Data Modifications/
08. Demo Partition Switching.wmv	11.5 MB
05. Demo Delta Table.wmv	6.8 MB
07. Partition Switching.wmv	2.3 MB
04. Delta Table.wmv	2.2 MB
03. Demo Restricted Data Modifications.wmv	2.1 MB
06. Drop Load Create.wmv	1.4 MB
01. Module Introduction.wmv	1.1 MB
02. Restricted Data Modifications.wmv	514.6 KB
/03. Leveraging Batch-Execution Mode/
09. Demo NOT IN Batch Execution Inhibitor.wmv	10.8 MB
05. Demo Verifying Batch Execution Mode.wmv	10.6 MB
07. Demo Serial Plan Batch Execution Inhibitor.wmv	9.0 MB
10. Demo Scalar Aggregate Batch Execution Inhibitor.wmv	6.7 MB
03. Batch Execution Mode.wmv	1.9 MB
06. Batch Execution Inibitors (1).wmv	1.7 MB
02. Traditional Row Execution Mode.wmv	1.3 MB
01. Module Introduction.wmv	1.2 MB
08. Batch Execution Inhibitors (2).wmv	1.0 MB
04. Batch Mode Operator Support.wmv	806.0 KB
/06. Deployment Planning/
05. Demo Index Creation Memory Requirements.wmv	9.1 MB
06. Deployment Considerations (1).wmv	2.7 MB
03. Index Creation Memory Requirements (1).wmv	1.8 MB
02. Interoperability Limitations.wmv	1.7 MB
08. vNext Clustered Columnstore Indexes.wmv	1.5 MB
07. Deployment Considerations (2).wmv	1.5 MB
09. Course Summary.wmv	1.2 MB
01. Module Introduction.wmv	1.1 MB
04. Index Creation Memory Requirements (2).wmv	1.0 MB
/01. Course Introduction/
02. Course Structure.wmv	1.6 MB
01. Course Introduction.wmv	1.3 MB
/Exercise Files/materials/
2-sqlserver2012-columnstore-m2-fundamentals-slides.pdf	882.3 KB
3-sqlserver2012-columnstore-m3-batchmode-slides.pdf	218.6 KB
4-sqlserver2012-columnstore-m4-benefits-slides.pdf	114.8 KB
6-sqlserver2012-columnstore-m6-deployment-slides.pdf	102.1 KB
5-sqlserver2012-columnstore-m5-datamod-slides.pdf	97.9 KB
1-sqlserver2012-columnstore-m1-intro-slides.pdf	83.3 KB
2-sqlserver2012-columnstore-m2-fundamentals-exercise-files.zip	4.3 KB
3-sqlserver2012-columnstore-m3-batchmode-exercise-files.zip	2.5 KB
5-sqlserver2012-columnstore-m5-datamod-exercise-files.zip	2.5 KB
6-sqlserver2012-columnstore-m6-deployment-exercise-files.zip	1.0 KB
4-sqlserver2012-columnstore-m4-benefits-exercise-files.zip	0.6 KB
Total files 64