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

Blogs

The End of PASS

By

I think our profession was the better for having a professional association, even if...

Platforms for Events

By

in my last post I wrote about thinking of the tools as being a...

Getting Started with Robotic Process Automation (RPA) Using the Power Automate Desktop

By

There are a lot of hot phrases you’ve likely heard thrown around during various...

Read the latest Blogs

Forums

Migrating from 2008/2012 SQLserver to new server with sqlserver2019

By caz100

Anyone have a guide on how I migrate SSIS from sqlserver 2008 / 2012...

sp_execute and sp_executesql and sp_prepexec for the same statement

By scott.laird

From our software provided by a third party vendor, I am seeing the following:...

"Home PC" SQL instance

By ifthir

This may be a bit non-typical, but I am currently running SQL 2019 Developer...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers