Optimizing Query Performance with Columnstore Indexes

File Name

Size

01. Course Overview/01. Course Overview.mp4

3.3 MB

01. Course Overview/01. Course Overview.srt

2.2 kB

02. Introducing Columnstore Indexes/01. Introduction.mp4

2.7 MB

02. Introducing Columnstore Indexes/01. Introduction.srt

2.3 kB

02. Introducing Columnstore Indexes/02. Why Is Columnstore Needed-.mp4

6.3 MB

02. Introducing Columnstore Indexes/02. Why Is Columnstore Needed-.srt

4.3 kB

02. Introducing Columnstore Indexes/03. What Is a Columnstore Index-.mp4

2.6 MB

02. Introducing Columnstore Indexes/03. What Is a Columnstore Index-.srt

2.2 kB

02. Introducing Columnstore Indexes/04. Demo- Creating Your Demo Environment.mp4

13 MB

02. Introducing Columnstore Indexes/04. Demo- Creating Your Demo Environment.srt

7.7 kB

02. Introducing Columnstore Indexes/05. Course Structure.mp4

3.8 MB

02. Introducing Columnstore Indexes/05. Course Structure.srt

4.0 kB

03. Examining the Structure of Columnstore Indexes/01. Introduction.mp4

3.7 MB

03. Examining the Structure of Columnstore Indexes/01. Introduction.srt

3.3 kB

03. Examining the Structure of Columnstore Indexes/02. Two Storage Methods.mp4

3.1 MB

03. Examining the Structure of Columnstore Indexes/02. Two Storage Methods.srt

3.2 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.6 kB

03. Examining the Structure of Columnstore Indexes/04. History of Columnstore Indexes.mp4

5.5 MB

03. Examining the Structure of Columnstore Indexes/04. History of Columnstore Indexes.srt

4.1 kB

03. Examining the Structure of Columnstore Indexes/05. Benefits of Columnstore Indexes.mp4

5.0 MB

03. Examining the Structure of Columnstore Indexes/05. Benefits of Columnstore Indexes.srt

3.5 kB

03. Examining the Structure of Columnstore Indexes/06. When You Should Pick or Skip Columnstore.mp4

4.4 MB

03. Examining the Structure of Columnstore Indexes/06. When You Should Pick or Skip Columnstore.srt

4.4 kB

03. Examining the Structure of Columnstore Indexes/07. Demo- Comparing Index Size.mp4

7.5 MB

03. Examining the Structure of Columnstore Indexes/07. Demo- Comparing Index Size.srt

5.4 kB

03. Examining the Structure of Columnstore Indexes/08. Summary.mp4

2.9 MB

03. Examining the Structure of Columnstore Indexes/08. Summary.srt

2.4 kB

04. Creating Your First Columnstore Index/01. Introduction.mp4

3.2 MB

04. Creating Your First Columnstore Index/01. Introduction.srt

3.0 kB

04. Creating Your First Columnstore Index/02. Types of Columnstore Indexes.mp4

3.0 MB

04. Creating Your First Columnstore Index/02. Types of Columnstore Indexes.srt

2.9 kB

04. Creating Your First Columnstore Index/03. Which Index to Choose.mp4

6.4 MB

04. Creating Your First Columnstore Index/03. Which Index to Choose.srt

4.6 kB

04. Creating Your First Columnstore Index/04. Which Index Should You Choose.mp4

3.3 MB

04. Creating Your First Columnstore Index/04. Which Index Should You Choose.srt

3.2 kB

04. Creating Your First Columnstore Index/05. Exploring Columnstore Storage.mp4

4.8 MB

04. Creating Your First Columnstore Index/05. Exploring Columnstore Storage.srt

5.7 kB

04. Creating Your First Columnstore Index/06. Reviewing Syntax.mp4

2.9 MB

04. Creating Your First Columnstore Index/06. Reviewing Syntax.srt

2.9 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.1 kB

04. Creating Your First Columnstore Index/08. Demo- Creating a Columnstore Index.mp4

11 MB

04. Creating Your First Columnstore Index/08. Demo- Creating a Columnstore Index.srt

7.1 kB

04. Creating Your First Columnstore Index/09. Demo- Segment Elimination.mp4

8.0 MB

04. Creating Your First Columnstore Index/09. Demo- Segment Elimination.srt

5.4 kB

04. Creating Your First Columnstore Index/10. Demo- SQL Server 2022 Ordered Columnstore Index.mp4

4.9 MB

04. Creating Your First Columnstore Index/10. Demo- SQL Server 2022 Ordered Columnstore Index.srt

3.0 kB

04. Creating Your First Columnstore Index/11. Summary.mp4

4.2 MB

04. Creating Your First Columnstore Index/11. Summary.srt

3.7 kB

05. Optimizing Columnstore Index Performance/01. Introduction.mp4

3.7 MB

05. Optimizing Columnstore Index Performance/01. Introduction.srt

3.5 kB

05. Optimizing Columnstore Index Performance/02. Batch Mode Execution.mp4

3.4 MB

05. Optimizing Columnstore Index Performance/02. Batch Mode Execution.srt

4.1 kB

05. Optimizing Columnstore Index Performance/03. Batch Mode Key Points.mp4

5.2 MB

05. Optimizing Columnstore Index Performance/03. Batch Mode Key Points.srt

3.9 kB

05. Optimizing Columnstore Index Performance/04. Demo- Batch Mode.mp4

12 MB

05. Optimizing Columnstore Index Performance/04. Demo- Batch Mode.srt

6.2 kB

05. Optimizing Columnstore Index Performance/05. Demo- Batch Mode on Rowstore.mp4

4.7 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

5.0 MB

05. Optimizing Columnstore Index Performance/06. Explore Aggregate Pushdown.srt

4.5 kB

05. Optimizing Columnstore Index Performance/07. Demo- Aggregate Pushdown.mp4

7.6 MB

05. Optimizing Columnstore Index Performance/07. Demo- Aggregate Pushdown.srt

4.4 kB

05. Optimizing Columnstore Index Performance/08. Explore String Predicate Pushdown.mp4

5.1 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.8 MB

05. Optimizing Columnstore Index Performance/09. Demo- String Predicate Pushdown.srt

4.0 kB

05. Optimizing Columnstore Index Performance/10. Adaptive Query Joins.mp4

4.5 MB

05. Optimizing Columnstore Index Performance/10. Adaptive Query Joins.srt

4.1 kB

05. Optimizing Columnstore Index Performance/11. Summary.mp4

2.9 MB

05. Optimizing Columnstore Index Performance/11. Summary.srt

2.4 kB

06. Monitoring and Maintaining Index Health/01. Introduction.mp4

2.9 MB

06. Monitoring and Maintaining Index Health/01. Introduction.srt

2.6 kB

06. Monitoring and Maintaining Index Health/02. Data Modifications.mp4

4.7 MB

06. Monitoring and Maintaining Index Health/02. Data Modifications.srt

5.2 kB

06. Monitoring and Maintaining Index Health/03. Demo- Data Modifications.mp4

8.2 MB

06. Monitoring and Maintaining Index Health/03. Demo- Data Modifications.srt

5.8 kB

06. Monitoring and Maintaining Index Health/04. Find Fragmentation.mp4

4.9 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.6 MB

06. Monitoring and Maintaining Index Health/05. Demo- Find Fragmentation.srt

4.3 kB

06. Monitoring and Maintaining Index Health/06. Fixing Fragmentation.mp4

7.1 MB

06. Monitoring and Maintaining Index Health/06. Fixing Fragmentation.srt

5.6 kB

06. Monitoring and Maintaining Index Health/07. Demo- Fixing Fragmentation.mp4

4.7 MB

06. Monitoring and Maintaining Index Health/07. Demo- Fixing Fragmentation.srt

3.3 kB

06. Monitoring and Maintaining Index Health/08. Summary.mp4

3.7 MB

06. Monitoring and Maintaining Index Health/08. Summary.srt

3.2 kB

07. Building Columnstore Indexes in the Real World/01. Introduction.mp4

5.7 MB

07. Building Columnstore Indexes in the Real World/01. Introduction.srt

4.5 kB

07. Building Columnstore Indexes in the Real World/02. Proving out Columnstore.mp4

5.9 MB

07. Building Columnstore Indexes in the Real World/02. Proving out Columnstore.srt

5.0 kB

07. Building Columnstore Indexes in the Real World/03. Demo- Proof of Concept Part 1.mp4

8.9 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 MB

07. Building Columnstore Indexes in the Real World/04. Demo- Proof of Concept Part 2.srt

6.2 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

6.0 kB

07. Building Columnstore Indexes in the Real World/06. Demo- Loading Data with Columnstore.mp4

7.0 MB

07. Building Columnstore Indexes in the Real World/06. Demo- Loading Data with Columnstore.srt

4.5 kB

07. Building Columnstore Indexes in the Real World/07. Key Takeaways.mp4

7.5 MB

07. Building Columnstore Indexes in the Real World/07. Key Takeaways.srt

5.4 kB

07. Building Columnstore Indexes in the Real World/08. Continue the Journey.mp4

3.6 MB

07. Building Columnstore Indexes in the Real World/08. Continue the Journey.srt

3.4 kB

optimizing-query-performance-columnstoreindexes.zip

16 MB