Optimizing Query Performance with Columnstore Indexes | B6C78A2EADA063B72F3DD90FB29C2063D8CEFB6E

Optimizing Query Performance with Columnstore Indexes

Name	Optimizing Query Performance with Columnstore Indexes	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	312.2 MB
Total Files	105
Last Seen
Hash	B6C78A2EADA063B72F3DD90FB29C2063D8CEFB6E

/01. Course Overview/
01. Course Overview.mp4	3.4 MB
01. Course Overview/
01. Course Overview.srt	2.2 KB
02. Introducing Columnstore Indexes/
01. Introduction.mp4	2.8 MB
01. Introduction.srt	2.4 KB
02. Why Is Columnstore Needed-.mp4	6.6 MB
02. Why Is Columnstore Needed-.srt	4.4 KB
03. What Is a Columnstore Index-.mp4	2.8 MB
03. What Is a Columnstore Index-.srt	2.2 KB
04. Demo- Creating Your Demo Environment.mp4	13.7 MB
04. Demo- Creating Your Demo Environment.srt	7.9 KB
05. Course Structure.mp4	4.0 MB
05. Course Structure.srt	4.1 KB
03. Examining the Structure of Columnstore Indexes/
01. Introduction.mp4	3.9 MB
01. Introduction.srt	3.3 KB
02. Two Storage Methods.mp4	3.3 MB
02. Two Storage Methods.srt	3.3 KB
03. How Is Data Physically Stored-.mp4	3.9 MB
03. How Is Data Physically Stored-.srt	3.7 KB
04. History of Columnstore Indexes.mp4	5.7 MB
04. History of Columnstore Indexes.srt	4.2 KB
05. Benefits of Columnstore Indexes.mp4	5.3 MB
05. Benefits of Columnstore Indexes.srt	3.5 KB
06. When You Should Pick or Skip Columnstore.mp4	4.6 MB
06. When You Should Pick or Skip Columnstore.srt	4.5 KB
07. Demo- Comparing Index Size.mp4	7.9 MB
07. Demo- Comparing Index Size.srt	5.5 KB
08. Summary.mp4	3.0 MB
08. Summary.srt	2.4 KB
04. Creating Your First Columnstore Index/
01. Introduction.mp4	3.3 MB
01. Introduction.srt	3.0 KB
02. Types of Columnstore Indexes.mp4	3.1 MB
02. Types of Columnstore Indexes.srt	2.9 KB
03. Which Index to Choose.mp4	6.7 MB
03. Which Index to Choose.srt	4.7 KB
04. Which Index Should You Choose.mp4	3.4 MB
04. Which Index Should You Choose.srt	3.3 KB
05. Exploring Columnstore Storage.mp4	5.0 MB
05. Exploring Columnstore Storage.srt	5.8 KB
06. Reviewing Syntax.mp4	3.0 MB
06. Reviewing Syntax.srt	3.0 KB
07. Considerations Before Creating.mp4	3.5 MB
07. Considerations Before Creating.srt	3.2 KB
08. Demo- Creating a Columnstore Index.mp4	11.2 MB
08. Demo- Creating a Columnstore Index.srt	7.2 KB
09. Demo- Segment Elimination.mp4	8.4 MB
09. Demo- Segment Elimination.srt	5.6 KB
10. Demo- SQL Server 2022 Ordered Columnstore Index.mp4	5.1 MB
10. Demo- SQL Server 2022 Ordered Columnstore Index.srt	3.1 KB
11. Summary.mp4	4.4 MB
11. Summary.srt	3.8 KB
05. Optimizing Columnstore Index Performance/
01. Introduction.mp4	3.8 MB
01. Introduction.srt	3.5 KB
02. Batch Mode Execution.mp4	3.5 MB
02. Batch Mode Execution.srt	4.2 KB
03. Batch Mode Key Points.mp4	5.5 MB
03. Batch Mode Key Points.srt	4.0 KB
04. Demo- Batch Mode.mp4	12.4 MB
04. Demo- Batch Mode.srt	6.4 KB
05. Demo- Batch Mode on Rowstore.mp4	4.9 MB
05. Demo- Batch Mode on Rowstore.srt	2.7 KB
06. Explore Aggregate Pushdown.mp4	5.2 MB
06. Explore Aggregate Pushdown.srt	4.6 KB
07. Demo- Aggregate Pushdown.mp4	8.0 MB
07. Demo- Aggregate Pushdown.srt	4.5 KB
08. Explore String Predicate Pushdown.mp4	5.4 MB
08. Explore String Predicate Pushdown.srt	4.2 KB
09. Demo- String Predicate Pushdown.mp4	7.1 MB
09. Demo- String Predicate Pushdown.srt	4.1 KB
10. Adaptive Query Joins.mp4	4.7 MB
10. Adaptive Query Joins.srt	4.2 KB
11. Summary.mp4	3.1 MB
11. Summary.srt	2.4 KB
06. Monitoring and Maintaining Index Health/
01. Introduction.mp4	3.1 MB
01. Introduction.srt	2.6 KB
02. Data Modifications.mp4	4.9 MB
02. Data Modifications.srt	5.3 KB
03. Demo- Data Modifications.mp4	8.6 MB
03. Demo- Data Modifications.srt	6.0 KB
04. Find Fragmentation.mp4	5.1 MB
04. Find Fragmentation.srt	4.7 KB
05. Demo- Find Fragmentation.mp4	5.9 MB
05. Demo- Find Fragmentation.srt	4.4 KB
06. Fixing Fragmentation.mp4	7.5 MB
06. Fixing Fragmentation.srt	5.7 KB
07. Demo- Fixing Fragmentation.mp4	4.9 MB
07. Demo- Fixing Fragmentation.srt	3.4 KB
08. Summary.mp4	3.8 MB
08. Summary.srt	3.2 KB
07. Building Columnstore Indexes in the Real World/
01. Introduction.mp4	5.9 MB
01. Introduction.srt	4.6 KB
02. Proving out Columnstore.mp4	6.2 MB
02. Proving out Columnstore.srt	5.1 KB
03. Demo- Proof of Concept Part 1.mp4	9.3 MB
03. Demo- Proof of Concept Part 1.srt	5.7 KB
04. Demo- Proof of Concept Part 2.mp4	10.7 MB
04. Demo- Proof of Concept Part 2.srt	6.4 KB
05. Demo- Shrink Big Tables with Columnstore.mp4	8.8 MB
05. Demo- Shrink Big Tables with Columnstore.srt	6.1 KB
06. Demo- Loading Data with Columnstore.mp4	7.3 MB
06. Demo- Loading Data with Columnstore.srt	4.6 KB
07. Key Takeaways.mp4	7.9 MB
07. Key Takeaways.srt	5.5 KB
08. Continue the Journey.mp4	3.8 MB
08. Continue the Journey.srt	3.4 KB

optimizing-query-performance-columnstoreindexes.zip	16.6 MB
Total files 105