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
━━━━━━━━━━━━━━━━━━━━━━━━━━