From the course: Designing Database Solutions for SQL Server 2016
Unlock the full course today
Join today to access over 23,300 courses taught by industry experts.
Row and Page compression strategies - SQL Server Tutorial
From the course: Designing Database Solutions for SQL Server 2016
Row and Page compression strategies
- [Instructor] It's not uncommon for databases to grow very large, which stresses not only the physical constraints of the hard drives, but also places increased load on network traffic. By implementing some compression strategies, you can make sure that your databases efficiently utilize the available resources. Because network speeds are so much slower than processing speed, it's possible to find efficiency gains by using processing power to compress data in a database so that it's smaller and can be transferred faster. And then, using processing power again on the receiving end to uncompress data back to its original state. The technique of data compression isn't for every database. Unfortunately it's only available on SQL Server Enterprise or Developer editions, not on Standard or Express. And it's most beneficial on databases or tables that experience a large number of transactions, and that have structures that are good candidates for efficient data compression. That said, there…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.