Optimizing Query Performance with Columnstore Indexes

Focused View

Jared Westover

2:33:10

16 View

1. Course Overview

1. Course Overview.mp4

01:39

2. Introducing Columnstore Indexes

1. Introduction.mp4

01:38

2. Why Is Columnstore Needed.mp4

02:53

3. What Is a Columnstore Index.mp4

01:40

4. Demo - Creating Your Demo Environment.mp4

05:47

5. Course Structure.mp4

02:45

3. Examining the Structure of Columnstore Indexes

1. Introduction.mp4

02:15

2. Two Storage Methods.mp4

02:18

3. How Is Data Physically Stored.mp4

02:25

4. History of Columnstore Indexes.mp4

03:04

5. Benefits of Columnstore Indexes.mp4

02:28

6. When You Should Pick or Skip Columnstore.mp4

03:07

7. Demo - Comparing Index Size.mp4

03:57

8. Summary.mp4

01:41

04. Creating Your First Columnstore Index

01. Introduction.mp4

01:57

02. Types of Columnstore Indexes.mp4

01:56

03. Which Index to Choose.mp4

03:10

04. Which Index Should You Choose.mp4

02:19

05. Exploring Columnstore Storage.mp4

03:53

06. Reviewing Syntax.mp4

02:05

07. Considerations Before Creating.mp4

02:01

08. Demo - Creating a Columnstore Index.mp4

04:57

09. Demo - Segment Elimination.mp4

03:54

10. Demo - SQL Server 2022 Ordered Columnstore Index.mp4

02:12

11. Summary.mp4

02:30

05. Optimizing Columnstore Index Performance

01. Introduction.mp4

02:20

02. Batch Mode Execution.mp4

02:55

03. Batch Mode Key Points.mp4

02:45

04. Demo - Batch Mode.mp4

04:48

05. Demo - Batch Mode on Rowstore.mp4

01:54

06. Explore Aggregate Pushdown.mp4

03:05

07. Demo - Aggregate Pushdown.mp4

03:16

08. Explore String Predicate Pushdown.mp4

02:49

09. Demo - String Predicate Pushdown.mp4

02:58

10. Adaptive Query Joins.mp4

03:03

11. Summary.mp4

01:47

6. Monitoring and Maintaining Index Health

1. Introduction.mp4

01:48

2. Data Modifications.mp4

03:26

3. Demo - Data Modifications.mp4

04:29

4. Find Fragmentation.mp4

02:50

5. Demo - Find Fragmentation.mp4

03:01

6. Fixing Fragmentation.mp4

03:44

7. Demo - Fixing Fragmentation.mp4

02:21

8. Summary.mp4

02:10

7. Building Columnstore Indexes in the Real World

1. Introduction.mp4

03:02

2. Proving out Columnstore.mp4

03:11

3. Demo - Proof of Concept Part 1.mp4

04:04

4. Demo - Proof of Concept Part 2.mp4

04:43

5. Demo - Shrink Big Tables with Columnstore.mp4

04:25

6. Demo - Loading Data with Columnstore.mp4

03:38

7. Key Takeaways.mp4

03:50

8. Continue the Journey.mp4

02:17

Description

Have you considered creating columnstore indexes to defeat slow queries? Well, this course is for you! Take your skills to the next level by learning how columnstore indexes can boost performance in today's busy database environment.

What You'll Learn?

High-performance queries are vital for any SQL developer in today's data- driven world. You may have tried columnstore indexes but left with more questions than answers. In this course, Optimizing Query Performance with Columnstore Indexes, you'll learn core skills for building columnstore indexes in your environment. First, you'll learn what columnstore is and how it differs from rowstore. Understanding the columnstore architecture helps you decide the correct path when it's time to implement. Next, you'll discover the various types of columnstore indexes and which one to create based on your database's workload. Also, you'll learn several features built into columnstore, allowing faster performance. Finally, you'll explore several techniques for getting the most from your new columnstore indexes. When you're finished with this course, you'll have the skills and knowledge necessary to implement and optimize columnstore indexes in your unique environment.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Big Data

Google BigQuery

Jared Westover

Instructor's Courses

Jared Westover is a Microsoft Certified Solutions Expert in Data Management and Analytics. When he started his education, he didn’t consider any other field than computers. Jared has been working with technology for over 15 years. He focuses on SQL Server and finding ways to tell inspiring stories with raw data. Technology became his first love while working on a Tandy back in the ’80s. Undertaking an epic quest, Jared wanted nothing more than to design video games using C. Working with data gives Jared a chance to combine his passions for technology and creativity. Tracking data, whether steps taken or money spent, has become an obsession. He loves spending time with his wonderful wife Amanda and three children in his spare time. Jared enjoys lifting weights, along with a good Netflix binge.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.