From the course: Developing Microsoft SQL Server 2016 Databases
Join today to access over 25,500 courses taught by industry experts.
Data compression fundamentals - SQL Server Tutorial
From the course: Developing Microsoft SQL Server 2016 Databases
Data compression fundamentals
- [Instructor] Input output, or IO, continues to be a bottle neck in moving information into our out of a database. Data compression takes advantage of this to help increase the efficiency of a database. Because network speeds are so much slower than processing speed, it's possible to find efficiency gains by using the processing power to compress data in a database, so that it travels faster. And then use processing power again, to un-compress the data on the other end. 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 and tables that experience a large number of transactions, and that also have data structures that are good candidates for efficient compression. That said, there are significant gains that can be had if your database is a good candidate.…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.