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

GotoWebinar (and Teams) won’t screen share after macOS update to Catalina (10.15)

By

This blog post is about the situation where after upgrading to the latest macOS...

Improving TweetDeck with Better TweetDeck

By

If you are at involved with the #sqlfamily, you are bound to hear about...

Interview with Bob Ward

By

This is the eight interview we have done. This time our guest is the...

Read the latest Blogs

Forums

https://dragonsdenketo.com/aqualeva-face-cream/

By VickieAndersion

Aqualeva Face Cream I know I sound like an infomercial offering Anti Aging Cream....

Protecting Data from the Inside

By Phil Factor

Comments posted to this topic are about the item Protecting Data from the Inside

Remove the middle of a string between wildcards

By ncraigg

I have a field called 'jsonpayload' in a table called 'auditlog' that is populated...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers