SQL Server Data Compression - Summit Preview

YouTube·PASS Data Community Summit

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.