Learn EDR Internals: Research & Development From The Masters
Advanced Techniques in Data Visualization - Self Paced Online
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
Explore data compression techniques in SQL Server with this 57-minute conference talk from the PASS Data Community Summit. Learn why compression is beneficial, discover its availability across all editions since SQL Server 2016 SP1, and understand different compression types. Dive into the mechanics of compression, focusing on page-level and column prefix methods. Watch a live demonstration comparing size and performance impacts, and gain insights into compression estimates and row versioning. Enhance your database optimization skills and leverage this powerful feature to improve storage efficiency and query performance, regardless of your organization's size or budget constraints.
Syllabus
Intro
Why use compression
Compression now available in all editions
Types of compression
How compression works
Pagelevel compression
Column prefix compression
Demo
Size Comparison
Performance Comparison
Estimates
Page Compression
Row Versioning
Questions
Taught by
PASS Data Community Summit