OK, so it’s one week to Christmas and I have to resort to a holiday theme of some sort. Things are a bit laid back this year. Our family has resorted to the Secret Santa thing to reduce the number of ...

Using compression with SSMS is just as easy. Simply set the compression option on the Options page of the Back up Database dialog. You may be asking yourself: How effective is this compression? The ...

Just keep in mind that the benefits you get from Data Compression (which works at the page level, replacing repeating data with lookup pointers) will depend on the nature of the data in your table and ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Dany Lepage discusses the architectural ...

Just keep in mind that the benefits you get from Data Compression (which works at the page level, replacing repeating data with lookup pointers) will depend on the nature of the data in your table and ...

The rapid expansion of data volumes in modern applications has intensified the need for efficient methods of storing and retrieving information. Contemporary research in data compression focuses on ...

I had a very nice chat late yesterday with Josh Berkus, who works as the Sun lead with PostgreSQL. After watching Sun suffer from "margin compression" for years, while transforming itself into an open ...