Featured resource
2026 Tech Forecast
2026 Tech Forecast

1,500+ tech insiders, business leaders, and Pluralsight Authors share their predictions on what’s shifting fastest and how to stay ahead.

Download the forecast
  • Course

Optimize Performance in SQL Server Data Warehouses

Data warehouses require a different approach to performance tuning than transactional databases. This course will teach you how to optimize SQL Server data warehouses by focusing on table design, indexing, compression, query tuning, and concurrency.

Intermediate
1h 46m

Created by Jared Westover

Last Updated Nov 18, 2026

Course Thumbnail
  • Course

Optimize Performance in SQL Server Data Warehouses

Data warehouses require a different approach to performance tuning than transactional databases. This course will teach you how to optimize SQL Server data warehouses by focusing on table design, indexing, compression, query tuning, and concurrency.

Intermediate
1h 46m

Created by Jared Westover

Last Updated Nov 18, 2026

Get started today

Access this course and other top-rated tech content with one of our business plans.

Try this course for free

Access this course and other top-rated tech content with one of our individual plans.

This course is included in the libraries shown below:

  • Data
What you'll learn

Performance tuning a SQL Server data warehouse requires a workload-specific approach that differs from tuning a transactional database. In this course, Optimize Performance in SQL Server Data Warehouses, you’ll gain the ability to make performance decisions based on the needs of analytical workloads. First, you’ll explore how table design, partitioning, compression, and indexing affect warehouse performance. Next, you’ll learn how to use columnstore indexes, statistics, execution plans, and query tuning techniques to improve analytical queries. Finally, you’ll learn how to monitor warehouse workloads and manage concurrency between data loads and reporting queries. When you’re finished with this course, you’ll have the skills and knowledge needed to make informed performance tuning decisions for SQL Server data warehouses.

Optimize Performance in SQL Server Data Warehouses
Intermediate
1h 46m
Table of contents

About the author
Jared Westover - Pluralsight course - Optimize Performance in SQL Server Data Warehouses
Jared Westover
18 courses 4.6 author rating 314 ratings

Jared Westover is a Microsoft Certified Solutions Expert in Data Management and Analytics. Data and technology have been paramount to his career for over 13 years. These days he focuses on SQL Server and finding ways to tell inspiring stories with raw data.

2025 Forrester Wave™ names Pluralsight as a Leader among tech skills dev platforms

See how our offering and strategy stack up.

forrester wave report