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

Daily Coping 17 Sep 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Ethics in Modern Data at Music City Tech 2021

By

  On Sept 16, Christine and I presented our joint presentation on Ethics in Modern Data at...

Slides and Video from Building a Regret-free Foundation for your Data Factory Now Available

By

Last week, Kerry and I delivered a webinar with tips on how to set...

Read the latest Blogs

Forums

SSRS Migration Question

By CiyonAart

So I have a SQL 2017 server that has the two Report Server Databases,...

What is the specific job of the SQL Developer position?

By AllanLloyd

I knew about the position of SQL Developer through an introductory newspaper. I found...

update final code where not contain x then null if not contain x and another cod

By ahmed_elbarbary.2010

i work on SQL server 2012 I face issue i can't update table replacement...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers