Data Compression

Storing E-mail addresses more efficiently in SQL Server - Part 2

  • Article

In my last tip, I shared some ideas for determining if you should consider breaking up the e-mail addresses you're storing, even putting the domain names in a separate table. I performed storage and timing comparisons for working with 10,000 unique e-mail addresses, but I completely ignored data compression. I wanted to revisit the same test case and apply data compression to the tables and see how that impacted the outcome.

2012-04-26

4,884 reads

Data Compression: Strategy, Capacity Planning and Best Practices

  • Article

The data compression feature in SQL Server 2008 helps compress the data inside a database, and it can help reduce the size of the database. Apart from the space savings, data compression provides another benefit: Because compressed data is stored in fewer pages, queries need to read fewer pages from the disk, thereby improving the performance of I/O intensive workloads. However, extra CPU resources are required on the database server to compress and decompress the data, while data is exchanged with the application. Therefore, it is important to understand the workload characteristics when deciding which tables to compress.

2009-08-11

2,717 reads

Blogs

Transforming JSON data with the help of Azure Data Factory - Part 4 - Passing Arrays around

By

(2020-May-24) It has never been my plan to write a series of articles about how...

3D Printing Ear Savers

By

On April 5th, I started printing ear savers for healthcare workers. I started with...

Updated Default Settings for Azure SQL Managed Instance Databases

By

A common saying about Azure is that it is always changing. This is a...

Read the latest Blogs

Forums

Golden Goose Sneakers popular

By ashoessaler

But thanks to the jolie laide shoe phenomenon (kick-started back in 2013 with Phoebe...

Configuring the Analysis Services Query Log still supported in SQL 2017/2019 ?

By Pierrot

Option seems to be still available, but I don't get it working. Latest documentation...

Are there application developers in here? Where are you doing your SQL?

By bbsimonbb

Hi, Are there app developers in this forum? Where does your app's SQL live?...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers