A Little About Index Compression In SQL Server скачать в хорошем качестве

A Little About Index Compression In SQL Server

In this video, I dive into the world of index compression in SQL Server, a feature that often gets overlooked despite its potential to significantly improve performance and reduce storage costs. I share my experience with standard edition users, who frequently hit memory limits, making page compression a particularly valuable tool. By creating indexes on both selective and unique columns, I demonstrate how page compression outperforms row compression in most scenarios, especially when dealing with large datasets or limited resources. The video includes practical examples and insights into the impact of compression on index size and memory usage, providing viewers with actionable knowledge to optimize their databases. CHAPTERS 00:00:00 - Introduction 00:01:44 - Standard Edition Limitations 00:03:54 - Index Compression Importance 00:06:21 - Training and Work Effort 00:08:39 - Data Compression Overview 00:09:02 - Page vs Row Compression 00:10:46 - Index Size Comparison 00:13:04 - Azure Costs Discussion 00:15:30 - Query Performance Analysis 00:17:12 - Memory Usage Benefits ━━━━━━━━━━━━━━━━━━━━━━━━━━ 📚 TRAINING & COURSES ━━━━━━━━━━━━━━━━━━━━━━━━━━ Get AI-Ready With Erik https://training.erikdarling.com/get-... SQL Server Performance Engineering Course https://training.erikdarling.com/sql-... Learn T-SQL with Erik https://training.erikdarling.com/lear... Everything Bundle: https://training.erikdarling.com/?cou... ━━━━━━━━━━━━━━━━━━━━━━━━━━ 🛠️ CONSULTING & SERVICES ━━━━━━━━━━━━━━━━━━━━━━━━━━ Need SQL Server performance help? https://training.erikdarling.com/sqlc... ━━━━━━━━━━━━━━━━━━━━━━━━━━ 💬 CONNECT ━━━━━━━━━━━━━━━━━━━━━━━━━━ Ask questions at Office Hours https://erikdarling.com/officehours/ Become a channel member    / @erikdarlingdata   ━━━━━━━━━━━━━━━━━━━━━━━━━━