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

Row and Page compression strategies - SQL Server Tutorial

From the course: Designing Database Solutions for SQL Server 2016

Start my 1-month free trial Buy for my team

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…

Contents