O'Reilly logo

Tribal SQL by Matt Velic, David Tate, Shaun J Stuart, Wil Sisney, Mark S Rasmussen, Bob Pusateri, Dev Nambi, Colleen Morrow, Stephanie Locke, Chuck Lathrope, Tara Kizer, Kevin Feasel, Diana Dee, John Barnett, Dave Ballantyne

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

SQL Server Data Compression

Bob Pusateri

Data compression, one of the many features introduced in SQL Server 2008, can help decrease the size of a database on disk, by reducing wasted space and eliminating duplicate data. Additionally, data compression can increase the speed of queries that perform high amounts of I/O, to and from disk, since each I/O operation can read or write more data.

Numbers will always vary from one environment to the next but, at my organization, the strategic deployment of data compression cut our overall database size on disk by nearly 50% and the execution time for key queries and processes by an average of 30%.

Nevertheless, DBAs must not take lightly the decision of when and where to deploy data compression; while ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required