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

A simple Machine Learning process example (supervised) – just to start with

By

I have just written the fifth article of the Machine Learning topic. !!! This...

Always On: Troubleshooting Consolidated

By

Working on Always On and configuration/setup of AG we have observed many errors. especially...

Changing Git Credentials in Windows

By

tl;dr For Windows when you need a different account. I had to work with...

Read the latest Blogs

Forums

SSRS page number by a certain column grouping

By Siten0308

Hello, I have been givin a task and not sure how to handle this,...

Best Work from Home training najafgarh

By ParminderSingh

Some work from home jobs require a bit of skill, experience, or credentials while...

SQL -> Oracle Linked Server DTC Error

By GonnaCatchIT

Dear Team, I am migrating from SQL 2008 to SQL 2014 for one of...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers