Optimizing Query Performance with Columnstore Indexes By jared-westover22

Download Now


Files Included :

01 Introduction.mp4 (3.76 MB)
MP4
02 Types of Columnstore Indexes.mp4 (3.62 MB)
MP4
03 Which Index to Choose.mp4 (9.67 MB)
MP4
04 Which Index Should You Choose.mp4 (4.16 MB)
MP4
05 Exploring Columnstore Storage.mp4 (5.9 MB)
MP4
06 Reviewing Syntax.mp4 (3.71 MB)
MP4
07 Considerations Before Creating.mp4 (4.69 MB)
MP4
08 Demo - Creating a Columnstore Index.mp4 (13.62 MB)
MP4
09 Demo - Segment Elimination.mp4 (10.38 MB)
MP4
10 Demo - SQL Server 2022 Ordered Columnstore Index.mp4 (6.03 MB)
MP4
11 Summary.mp4 (5 MB)
MP4
01 Introduction.mp4 (4.29 MB)
MP4
02 Batch Mode Execution.mp4 (3.95 MB)
MP4
03 Batch Mode Key Points.mp4 (8.55 MB)
MP4
04 Demo - Batch Mode.mp4 (17.01 MB)
MP4
05 Demo - Batch Mode on Rowstore.mp4 (5.9 MB)
MP4
06 Explore Aggregate Pushdown.mp4 (6.1 MB)
MP4
07 Demo - Aggregate Pushdown.mp4 (9.9 MB)
MP4
08 Explore String Predicate Pushdown.mp4 (6.62 MB)
MP4
09 Demo - String Predicate Pushdown.mp4 (10.03 MB)
MP4
10 Adaptive Query Joins.mp4 (5.87 MB)
MP4
11 Summary.mp4 (3.57 MB)
MP4
1 Course Overview.mp4 (3.73 MB)
MP4
1 Introduction.mp4 (3.39 MB)
MP4
2 Why Is Columnstore Needed.mp4 (7.89 MB)
MP4
3 What Is a Columnstore Index.mp4 (3.15 MB)
MP4
4 Demo - Creating Your Demo Environment.mp4 (16.24 MB)
MP4
5 Course Structure.mp4 (4.78 MB)
MP4
1 Introduction.mp4 (4.42 MB)
MP4
2 Two Storage Methods.mp4 (3.63 MB)
MP4
3 How Is Data Physically Stored.mp4 (4.19 MB)
MP4
4 History of Columnstore Indexes.mp4 (7.05 MB)
MP4
5 Benefits of Columnstore Indexes.mp4 (7.74 MB)
MP4
6 When You Should Pick or Skip Columnstore.mp4 (5.82 MB)
MP4
7 Demo - Comparing Index Size.mp4 (10.1 MB)
MP4
8 Summary.mp4 (3.34 MB)
MP4
1 Introduction.mp4 (3.56 MB)
MP4
2 Data Modifications.mp4 (6.13 MB)
MP4
3 Demo - Data Modifications.mp4 (10.48 MB)
MP4
4 Find Fragmentation.mp4 (7.85 MB)
MP4
5 Demo - Find Fragmentation.mp4 (7.25 MB)
MP4
6 Fixing Fragmentation.mp4 (11.17 MB)
MP4
7 Demo - Fixing Fragmentation.mp4 (6.93 MB)
MP4
8 Summary.mp4 (4.27 MB)
MP4
1 Introduction.mp4 (6.96 MB)
MP4
2 Proving out Columnstore.mp4 (9.2 MB)
MP4
3 Demo - Proof of Concept Part 1.mp4 (13.43 MB)
MP4
4 Demo - Proof of Concept Part 2.mp4 (15.44 MB)
MP4
5 Demo - Shrink Big Tables with Columnstore.mp4 (10.51 MB)
MP4
6 Demo - Loading Data with Columnstore.mp4 (8.34 MB)
MP4
7 Key Takeaways.mp4 (11.64 MB)
MP4
8 Continue the Journey.mp4 (4.13 MB)
MP4