Optimizing Query Performance with Columnstore Indexes
大小
297.72 MB
文件数
105
Info Hash:
B6C78A2EADA063B72F3DD90FB29C2063D8CEFB6E
收录时间
2026-03-18 23:58:49
更新时间
2026-03-18 23:58:49
文件列表 (105)
01. Course Overview/01. Course Overview.mp4
3.26 MB
01. Course Overview/01. Course Overview.srt
2.17 KB
02. Introducing Columnstore Indexes/01. Introduction.mp4
2.69 MB
02. Introducing Columnstore Indexes/01. Introduction.srt
2.32 KB
02. Introducing Columnstore Indexes/02. Why Is Columnstore Needed-.mp4
6.28 MB
02. Introducing Columnstore Indexes/02. Why Is Columnstore Needed-.srt
4.28 KB
02. Introducing Columnstore Indexes/03. What Is a Columnstore Index-.mp4
2.64 MB
02. Introducing Columnstore Indexes/03. What Is a Columnstore Index-.srt
2.17 KB
02. Introducing Columnstore Indexes/04. Demo- Creating Your Demo Environment.mp4
13.07 MB
02. Introducing Columnstore Indexes/04. Demo- Creating Your Demo Environment.srt
7.7 KB
02. Introducing Columnstore Indexes/05. Course Structure.mp4
3.77 MB
02. Introducing Columnstore Indexes/05. Course Structure.srt
4.01 KB
03. Examining the Structure of Columnstore Indexes/01. Introduction.mp4
3.71 MB
03. Examining the Structure of Columnstore Indexes/01. Introduction.srt
3.26 KB
03. Examining the Structure of Columnstore Indexes/02. Two Storage Methods.mp4
3.13 MB
03. Examining the Structure of Columnstore Indexes/02. Two Storage Methods.srt
3.23 KB
03. Examining the Structure of Columnstore Indexes/03. How Is Data Physically Stored-.mp4
3.7 MB
03. Examining the Structure of Columnstore Indexes/03. How Is Data Physically Stored-.srt
3.57 KB
03. Examining the Structure of Columnstore Indexes/04. History of Columnstore Indexes.mp4
5.48 MB
03. Examining the Structure of Columnstore Indexes/04. History of Columnstore Indexes.srt
4.11 KB
03. Examining the Structure of Columnstore Indexes/05. Benefits of Columnstore Indexes.mp4
5.03 MB
03. Examining the Structure of Columnstore Indexes/05. Benefits of Columnstore Indexes.srt
3.46 KB
03. Examining the Structure of Columnstore Indexes/06. When You Should Pick or Skip Columnstore.mp4
4.42 MB
03. Examining the Structure of Columnstore Indexes/06. When You Should Pick or Skip Columnstore.srt
4.43 KB
03. Examining the Structure of Columnstore Indexes/07. Demo- Comparing Index Size.mp4
7.52 MB
03. Examining the Structure of Columnstore Indexes/07. Demo- Comparing Index Size.srt
5.36 KB
03. Examining the Structure of Columnstore Indexes/08. Summary.mp4
2.87 MB
03. Examining the Structure of Columnstore Indexes/08. Summary.srt
2.38 KB
04. Creating Your First Columnstore Index/01. Introduction.mp4
3.18 MB
04. Creating Your First Columnstore Index/01. Introduction.srt
2.96 KB
04. Creating Your First Columnstore Index/02. Types of Columnstore Indexes.mp4
2.99 MB
04. Creating Your First Columnstore Index/02. Types of Columnstore Indexes.srt
2.86 KB
04. Creating Your First Columnstore Index/03. Which Index to Choose.mp4
6.38 MB
04. Creating Your First Columnstore Index/03. Which Index to Choose.srt
4.58 KB
04. Creating Your First Columnstore Index/04. Which Index Should You Choose.mp4
3.28 MB
04. Creating Your First Columnstore Index/04. Which Index Should You Choose.srt
3.25 KB
04. Creating Your First Columnstore Index/05. Exploring Columnstore Storage.mp4
4.79 MB
04. Creating Your First Columnstore Index/05. Exploring Columnstore Storage.srt
5.71 KB
04. Creating Your First Columnstore Index/06. Reviewing Syntax.mp4
2.86 MB
04. Creating Your First Columnstore Index/06. Reviewing Syntax.srt
2.93 KB
04. Creating Your First Columnstore Index/07. Considerations Before Creating.mp4
3.3 MB
04. Creating Your First Columnstore Index/07. Considerations Before Creating.srt
3.09 KB
04. Creating Your First Columnstore Index/08. Demo- Creating a Columnstore Index.mp4
10.69 MB
04. Creating Your First Columnstore Index/08. Demo- Creating a Columnstore Index.srt
7.05 KB
04. Creating Your First Columnstore Index/09. Demo- Segment Elimination.mp4
8 MB
04. Creating Your First Columnstore Index/09. Demo- Segment Elimination.srt
5.43 KB
04. Creating Your First Columnstore Index/10. Demo- SQL Server 2022 Ordered Columnstore Index.mp4
4.89 MB
04. Creating Your First Columnstore Index/10. Demo- SQL Server 2022 Ordered Columnstore Index.srt
3.04 KB
04. Creating Your First Columnstore Index/11. Summary.mp4
4.22 MB
04. Creating Your First Columnstore Index/11. Summary.srt
3.67 KB
05. Optimizing Columnstore Index Performance/01. Introduction.mp4
3.66 MB
05. Optimizing Columnstore Index Performance/01. Introduction.srt
3.46 KB
05. Optimizing Columnstore Index Performance/02. Batch Mode Execution.mp4
3.37 MB
05. Optimizing Columnstore Index Performance/02. Batch Mode Execution.srt
4.09 KB
05. Optimizing Columnstore Index Performance/03. Batch Mode Key Points.mp4
5.22 MB
05. Optimizing Columnstore Index Performance/03. Batch Mode Key Points.srt
3.92 KB
05. Optimizing Columnstore Index Performance/04. Demo- Batch Mode.mp4
11.8 MB
05. Optimizing Columnstore Index Performance/04. Demo- Batch Mode.srt
6.23 KB
05. Optimizing Columnstore Index Performance/05. Demo- Batch Mode on Rowstore.mp4
4.69 MB
05. Optimizing Columnstore Index Performance/05. Demo- Batch Mode on Rowstore.srt
2.6 KB
05. Optimizing Columnstore Index Performance/06. Explore Aggregate Pushdown.mp4
4.98 MB
05. Optimizing Columnstore Index Performance/06. Explore Aggregate Pushdown.srt
4.51 KB
05. Optimizing Columnstore Index Performance/07. Demo- Aggregate Pushdown.mp4
7.61 MB
05. Optimizing Columnstore Index Performance/07. Demo- Aggregate Pushdown.srt
4.44 KB
05. Optimizing Columnstore Index Performance/08. Explore String Predicate Pushdown.mp4
5.14 MB
05. Optimizing Columnstore Index Performance/08. Explore String Predicate Pushdown.srt
4.1 KB
05. Optimizing Columnstore Index Performance/09. Demo- String Predicate Pushdown.mp4
6.77 MB
05. Optimizing Columnstore Index Performance/09. Demo- String Predicate Pushdown.srt
3.96 KB
05. Optimizing Columnstore Index Performance/10. Adaptive Query Joins.mp4
4.49 MB
05. Optimizing Columnstore Index Performance/10. Adaptive Query Joins.srt
4.13 KB
05. Optimizing Columnstore Index Performance/11. Summary.mp4
2.94 MB
05. Optimizing Columnstore Index Performance/11. Summary.srt
2.35 KB
06. Monitoring and Maintaining Index Health/01. Introduction.mp4
2.95 MB
06. Monitoring and Maintaining Index Health/01. Introduction.srt
2.58 KB
06. Monitoring and Maintaining Index Health/02. Data Modifications.mp4
4.71 MB
06. Monitoring and Maintaining Index Health/02. Data Modifications.srt
5.22 KB
06. Monitoring and Maintaining Index Health/03. Demo- Data Modifications.mp4
8.24 MB
06. Monitoring and Maintaining Index Health/03. Demo- Data Modifications.srt
5.83 KB
06. Monitoring and Maintaining Index Health/04. Find Fragmentation.mp4
4.88 MB
06. Monitoring and Maintaining Index Health/04. Find Fragmentation.srt
4.6 KB
06. Monitoring and Maintaining Index Health/05. Demo- Find Fragmentation.mp4
5.62 MB
06. Monitoring and Maintaining Index Health/05. Demo- Find Fragmentation.srt
4.26 KB
06. Monitoring and Maintaining Index Health/06. Fixing Fragmentation.mp4
7.11 MB
06. Monitoring and Maintaining Index Health/06. Fixing Fragmentation.srt
5.58 KB
06. Monitoring and Maintaining Index Health/07. Demo- Fixing Fragmentation.mp4
4.66 MB
06. Monitoring and Maintaining Index Health/07. Demo- Fixing Fragmentation.srt
3.29 KB
06. Monitoring and Maintaining Index Health/08. Summary.mp4
3.67 MB
06. Monitoring and Maintaining Index Health/08. Summary.srt
3.16 KB
07. Building Columnstore Indexes in the Real World/01. Introduction.mp4
5.66 MB
07. Building Columnstore Indexes in the Real World/01. Introduction.srt
4.52 KB
07. Building Columnstore Indexes in the Real World/02. Proving out Columnstore.mp4
5.88 MB
07. Building Columnstore Indexes in the Real World/02. Proving out Columnstore.srt
4.98 KB
07. Building Columnstore Indexes in the Real World/03. Demo- Proof of Concept Part 1.mp4
8.86 MB
07. Building Columnstore Indexes in the Real World/03. Demo- Proof of Concept Part 1.srt
5.6 KB
07. Building Columnstore Indexes in the Real World/04. Demo- Proof of Concept Part 2.mp4
10.17 MB
07. Building Columnstore Indexes in the Real World/04. Demo- Proof of Concept Part 2.srt
6.25 KB
07. Building Columnstore Indexes in the Real World/05. Demo- Shrink Big Tables with Columnstore.mp4
8.4 MB
07. Building Columnstore Indexes in the Real World/05. Demo- Shrink Big Tables with Columnstore.srt
5.97 KB
07. Building Columnstore Indexes in the Real World/06. Demo- Loading Data with Columnstore.mp4
6.99 MB
07. Building Columnstore Indexes in the Real World/06. Demo- Loading Data with Columnstore.srt
4.54 KB
07. Building Columnstore Indexes in the Real World/07. Key Takeaways.mp4
7.51 MB
07. Building Columnstore Indexes in the Real World/07. Key Takeaways.srt
5.41 KB
07. Building Columnstore Indexes in the Real World/08. Continue the Journey.mp4
3.59 MB
07. Building Columnstore Indexes in the Real World/08. Continue the Journey.srt
3.35 KB
optimizing-query-performance-columnstoreindexes.zip
15.81 MB