1. Course Overview\1. Course Overview.mp4 |
3,592,115 |
CA66B93B |
1. Course Overview\1. Course Overview.srt |
2,667 |
72687D3C |
2. Exploring the Benefits of Columnstore Indexes\01. Introduction.mp4 |
4,807,384 |
F8A52CC5 |
2. Exploring the Benefits of Columnstore Indexes\01. Introduction.srt |
5,341 |
41285407 |
2. Exploring the Benefits of Columnstore Indexes\02. Solving Slow-running Reports.mp4 |
4,737,636 |
F82476D5 |
2. Exploring the Benefits of Columnstore Indexes\02. Solving Slow-running Reports.srt |
5,377 |
C42845F9 |
2. Exploring the Benefits of Columnstore Indexes\03. Defining a Columnstore Index.mp4 |
4,100,630 |
EE68BEFF |
2. Exploring the Benefits of Columnstore Indexes\03. Defining a Columnstore Index.srt |
4,679 |
984EF065 |
2. Exploring the Benefits of Columnstore Indexes\04. How Data Is Stored.mp4 |
4,743,005 |
FAC8CA41 |
2. Exploring the Benefits of Columnstore Indexes\04. How Data Is Stored.srt |
4,559 |
5EBCC0EE |
2. Exploring the Benefits of Columnstore Indexes\05. Evolving Columnstore.mp4 |
4,713,299 |
C8C01297 |
2. Exploring the Benefits of Columnstore Indexes\05. Evolving Columnstore.srt |
5,557 |
140C3677 |
2. Exploring the Benefits of Columnstore Indexes\06. Exploring Columnstore Benefits.mp4 |
5,416,718 |
07E37BB5 |
2. Exploring the Benefits of Columnstore Indexes\06. Exploring Columnstore Benefits.srt |
5,161 |
537AF67A |
2. Exploring the Benefits of Columnstore Indexes\07. Choosing Columnstore.mp4 |
3,780,703 |
9972EE51 |
2. Exploring the Benefits of Columnstore Indexes\07. Choosing Columnstore.srt |
4,181 |
8E607E7F |
2. Exploring the Benefits of Columnstore Indexes\08. Skipping Columnstore.mp4 |
3,474,076 |
DC05D7E2 |
2. Exploring the Benefits of Columnstore Indexes\08. Skipping Columnstore.srt |
4,153 |
CC86C7C5 |
2. Exploring the Benefits of Columnstore Indexes\09. Demo. Creating Our Test Environment.mp4 |
27,116,405 |
63993881 |
2. Exploring the Benefits of Columnstore Indexes\09. Demo. Creating Our Test Environment.srt |
11,584 |
36964E93 |
2. Exploring the Benefits of Columnstore Indexes\10. Demo. Comparing Index Size.mp4 |
16,263,754 |
EC935707 |
2. Exploring the Benefits of Columnstore Indexes\10. Demo. Comparing Index Size.srt |
8,189 |
09EB174B |
2. Exploring the Benefits of Columnstore Indexes\11. Summary.mp4 |
4,146,881 |
24852BF9 |
2. Exploring the Benefits of Columnstore Indexes\11. Summary.srt |
4,448 |
DC615D97 |
3. Creating Our First Columnstore Index\01. Introduction.mp4 |
5,348,504 |
AE9EEAF6 |
3. Creating Our First Columnstore Index\01. Introduction.srt |
5,859 |
A8A39BD9 |
3. Creating Our First Columnstore Index\02. Identifying Index Types.mp4 |
3,278,204 |
9B1AD8EE |
3. Creating Our First Columnstore Index\02. Identifying Index Types.srt |
3,896 |
72795F4B |
3. Creating Our First Columnstore Index\03. Choosing an Index.mp4 |
5,940,577 |
BB5B0A6A |
3. Creating Our First Columnstore Index\03. Choosing an Index.srt |
5,956 |
FAE95F6D |
3. Creating Our First Columnstore Index\04. Making a Final Decision.mp4 |
4,832,000 |
96DF7EE3 |
3. Creating Our First Columnstore Index\04. Making a Final Decision.srt |
4,700 |
F924A774 |
3. Creating Our First Columnstore Index\05. Examining Columnstore Storage.mp4 |
6,359,868 |
E60ED77E |
3. Creating Our First Columnstore Index\05. Examining Columnstore Storage.srt |
7,599 |
F3537FAE |
3. Creating Our First Columnstore Index\06. Defining Columnstore Syntax.mp4 |
3,337,524 |
F9D80425 |
3. Creating Our First Columnstore Index\06. Defining Columnstore Syntax.srt |
3,641 |
B6CA30C7 |
3. Creating Our First Columnstore Index\07. Considerations before Creating.mp4 |
4,763,919 |
0BF37A6E |
3. Creating Our First Columnstore Index\07. Considerations before Creating.srt |
4,479 |
8A7CD55A |
3. Creating Our First Columnstore Index\08. Demo. Creating Columnstore Indexes.mp4 |
21,408,887 |
5DC57AE1 |
3. Creating Our First Columnstore Index\08. Demo. Creating Columnstore Indexes.srt |
10,830 |
D8AF8D76 |
3. Creating Our First Columnstore Index\09. Demo. Segment Elimination.mp4 |
19,185,755 |
A2002410 |
3. Creating Our First Columnstore Index\09. Demo. Segment Elimination.srt |
9,264 |
DF20CE6C |
3. Creating Our First Columnstore Index\10. Summary.mp4 |
5,649,797 |
89E768C5 |
3. Creating Our First Columnstore Index\10. Summary.srt |
5,937 |
2A19AC37 |
4. Optimizing Columnstore Index Performance\01. Introduction.mp4 |
5,010,226 |
3F1C7425 |
4. Optimizing Columnstore Index Performance\01. Introduction.srt |
5,609 |
8334F399 |
4. Optimizing Columnstore Index Performance\02. Examining Execution Modes.mp4 |
4,178,808 |
D4EB6CDA |
4. Optimizing Columnstore Index Performance\02. Examining Execution Modes.srt |
5,189 |
D79BE4FC |
4. Optimizing Columnstore Index Performance\03. Reviewing Batch Mode Execution.mp4 |
5,014,044 |
D8F8023A |
4. Optimizing Columnstore Index Performance\03. Reviewing Batch Mode Execution.srt |
4,961 |
FC36E902 |
4. Optimizing Columnstore Index Performance\04. Demo. Batch Mode Execution.mp4 |
22,352,515 |
A419F817 |
4. Optimizing Columnstore Index Performance\04. Demo. Batch Mode Execution.srt |
10,287 |
B3789424 |
4. Optimizing Columnstore Index Performance\05. Demo. Batch Mode on Rowstore.mp4 |
10,448,016 |
0761485C |
4. Optimizing Columnstore Index Performance\05. Demo. Batch Mode on Rowstore.srt |
4,220 |
31A47E52 |
4. Optimizing Columnstore Index Performance\06. Exploring Aggregate Pushdown.mp4 |
6,268,798 |
A5908DD0 |
4. Optimizing Columnstore Index Performance\06. Exploring Aggregate Pushdown.srt |
6,210 |
63CFFE67 |
4. Optimizing Columnstore Index Performance\07. Demo. Aggregate Pushdown.mp4 |
14,354,498 |
CDECD7AA |
4. Optimizing Columnstore Index Performance\07. Demo. Aggregate Pushdown.srt |
7,326 |
46E430B7 |
4. Optimizing Columnstore Index Performance\08. Exploring String Predicate Pushdown.mp4 |
5,372,001 |
C8BBE8C2 |
4. Optimizing Columnstore Index Performance\08. Exploring String Predicate Pushdown.srt |
5,522 |
CE44993F |
4. Optimizing Columnstore Index Performance\09. Demo. String Predicate Pushdown.mp4 |
11,043,461 |
38207E63 |
4. Optimizing Columnstore Index Performance\09. Demo. String Predicate Pushdown.srt |
5,753 |
E2DDFA0C |
4. Optimizing Columnstore Index Performance\10. Adaptive Query Processing.mp4 |
4,491,864 |
C969E3B4 |
4. Optimizing Columnstore Index Performance\10. Adaptive Query Processing.srt |
4,049 |
98A60415 |
4. Optimizing Columnstore Index Performance\11. Summary.mp4 |
4,223,600 |
5665DB42 |
4. Optimizing Columnstore Index Performance\11. Summary.srt |
4,548 |
BD084E3F |
5. Monitoring and Maintaining Index Health\1. Introduction.mp4 |
5,035,441 |
828746DF |
5. Monitoring and Maintaining Index Health\1. Introduction.srt |
5,536 |
850C4C1F |
5. Monitoring and Maintaining Index Health\2. Modifying Data.mp4 |
6,060,326 |
24C7799C |
5. Monitoring and Maintaining Index Health\2. Modifying Data.srt |
6,313 |
94CC1B42 |
5. Monitoring and Maintaining Index Health\3. Demo. Modifying Data.mp4 |
17,803,167 |
481C584D |
5. Monitoring and Maintaining Index Health\3. Demo. Modifying Data.srt |
8,982 |
EC3746C1 |
5. Monitoring and Maintaining Index Health\4. Exploring Fragmentation.mp4 |
5,399,409 |
6857EAB7 |
5. Monitoring and Maintaining Index Health\4. Exploring Fragmentation.srt |
5,511 |
2204761A |
5. Monitoring and Maintaining Index Health\5. Demo. Finding Fragmentation.mp4 |
13,559,251 |
B9F4DFFE |
5. Monitoring and Maintaining Index Health\5. Demo. Finding Fragmentation.srt |
7,233 |
BA0E62CC |
5. Monitoring and Maintaining Index Health\6. Fixing Fragmentation.mp4 |
6,705,214 |
8614BEDA |
5. Monitoring and Maintaining Index Health\6. Fixing Fragmentation.srt |
7,056 |
9AD6AC52 |
5. Monitoring and Maintaining Index Health\7. Demo. Fixing Fragmentation.mp4 |
10,867,669 |
676597A0 |
5. Monitoring and Maintaining Index Health\7. Demo. Fixing Fragmentation.srt |
5,591 |
5D4D2DDB |
5. Monitoring and Maintaining Index Health\8. Summary.mp4 |
3,960,992 |
A9184AB8 |
5. Monitoring and Maintaining Index Health\8. Summary.srt |
4,280 |
64EED84F |
6. Building Columnstore Indexes in the Real World\1. Introduction.mp4 |
5,821,175 |
F1444011 |
6. Building Columnstore Indexes in the Real World\1. Introduction.srt |
6,278 |
BFE0CE32 |
6. Building Columnstore Indexes in the Real World\2. Proving out Columnstore Indexes.mp4 |
5,183,119 |
8D1B3B9C |
6. Building Columnstore Indexes in the Real World\2. Proving out Columnstore Indexes.srt |
5,806 |
B165D901 |
6. Building Columnstore Indexes in the Real World\3. Demo. Proof of Concept Part 1.mp4 |
20,675,080 |
D7F3023E |
6. Building Columnstore Indexes in the Real World\3. Demo. Proof of Concept Part 1.srt |
9,153 |
FB6FFBD4 |
6. Building Columnstore Indexes in the Real World\4. Demo. Proof of Concept Part 2.mp4 |
19,500,960 |
769797C5 |
6. Building Columnstore Indexes in the Real World\4. Demo. Proof of Concept Part 2.srt |
10,091 |
0009418B |
6. Building Columnstore Indexes in the Real World\5. Reviewing Key Takeaways.mp4 |
5,322,392 |
8175C608 |
6. Building Columnstore Indexes in the Real World\5. Reviewing Key Takeaways.srt |
5,787 |
91B8FF39 |
6. Building Columnstore Indexes in the Real World\6. Continuing the Journey.mp4 |
3,133,378 |
4F82C66B |
6. Building Columnstore Indexes in the Real World\6. Continuing the Journey.srt |
3,791 |
31D361ED |
Exercise Files\02\demos\m2-demos\01_Creating_Demo_Environment_Part1.sql |
4,497 |
90C922A6 |
Exercise Files\02\demos\m2-demos\01_Creating_Demo_Environment_Part2.sql |
331,294 |
97F47128 |
Exercise Files\02\demos\m2-demos\02_Comparing_Index_Sizes.sql |
1,634 |
75CF0B4D |
Exercise Files\02\exploring-the-benefits-of-columnstore-indexes-slides.pdf |
865,387 |
557DBB7F |
Exercise Files\03\creating-our-first-columnstore-index-slides.pdf |
916,332 |
A2242D25 |
Exercise Files\03\demos\m3-demos\01_Creating_Columnstore_Indexes.sql |
2,206 |
AF95D2A9 |
Exercise Files\03\demos\m3-demos\02_Exploring_Segment_Elimination.sql |
1,632 |
4FB46AD8 |
Exercise Files\04\demos\m4-demos\01_Batch_Mode.sql |
3,329 |
1B6E68C2 |
Exercise Files\04\demos\m4-demos\01_Batch_Mode_Part2.sql |
701 |
0EAF5B4B |
Exercise Files\04\demos\m4-demos\02_Aggregate_Pushdown.sql |
1,480 |
852AD5ED |
Exercise Files\04\demos\m4-demos\03_String_Predicate_Pushdown.sql |
1,123 |
37BFE781 |
Exercise Files\04\optimizing-columnstore-index-performance-slides.pdf |
879,789 |
D13D5F08 |
Exercise Files\05\demos\m5-demos\01_Data_Modifications.sql |
2,790 |
C1BE351C |
Exercise Files\05\demos\m5-demos\02_Detecting_Fragmentation.sql |
2,157 |
96A56FA0 |
Exercise Files\05\demos\m5-demos\03_Eliminating_Fragmentation.sql |
2,358 |
D49180BD |
Exercise Files\05\monitoring-and-maintaining-index-health-slides.pdf |
543,081 |
C043337F |
Exercise Files\06\building-columnstore-indexes-in-the-real-world-slides.pdf |
312,020 |
54A4BD98 |
Exercise Files\06\demos\m6-demos\01_Proof_of_Concept_Part_1.sql |
3,115 |
13561479 |
Exercise Files\06\demos\m6-demos\01_Proof_of_Concept_Part_2.sql |
4,620 |
09277D27 |
Exercise Files\02\demos\m2-demos |
0 |
00000000 |
Exercise Files\03\demos\m3-demos |
0 |
00000000 |
Exercise Files\04\demos\m4-demos |
0 |
00000000 |
Exercise Files\05\demos\m5-demos |
0 |
00000000 |
Exercise Files\06\demos\m6-demos |
0 |
00000000 |
Exercise Files\02\demos |
0 |
00000000 |
Exercise Files\03\demos |
0 |
00000000 |
Exercise Files\04\demos |
0 |
00000000 |
Exercise Files\05\demos |
0 |
00000000 |
Exercise Files\06\demos |
0 |
00000000 |
Exercise Files\02 |
0 |
00000000 |
Exercise Files\03 |
0 |
00000000 |
Exercise Files\04 |
0 |
00000000 |
Exercise Files\05 |
0 |
00000000 |
Exercise Files\06 |
0 |
00000000 |
1. Course Overview |
0 |
00000000 |
2. Exploring the Benefits of Columnstore Indexes |
0 |
00000000 |
3. Creating Our First Columnstore Index |
0 |
00000000 |
4. Optimizing Columnstore Index Performance |
0 |
00000000 |
5. Monitoring and Maintaining Index Health |
0 |
00000000 |
6. Building Columnstore Indexes in the Real World |
0 |
00000000 |
Exercise Files |
0 |
00000000 |
|
Total size: |
392,945,729 |
|