What's new

Welcome to Free download educational resource and Apps from TUTBB

Join us now to get access to all our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, and so, so much more. It's also quick and totally free, so what are you waiting for?

Optimize Performance in SQL Server Data Warehouses

TUTBB

Active member
Joined
Apr 9, 2022
Messages
196,445
Reaction score
20
Points
38

da163771bb7a81b6ae01b4fe8d0f899d.webp

Optimize Performance in SQL Server Data Warehouses
Released 11/2026
By Jared Westover
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz, 2 Ch
Level: Intermediate | Genre: eLearning | Language: English + subtitle | Duration: 1h 46m 21s | Size: 433.7 MB
Performance tuning a SQL Server data warehouse requires a workload-specific approach that differs from tuning a transactional database.
​


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.

Homepage
Code:
https://app.pluralsight.com/ilx/video-courses/sql-server-data-warehouse-optimize-performance/course-overview

 
Top Bottom