Storing E-mail addresses more efficiently in SQL Server

Posted on SQL Server Central See other posts from SQL Server Central
Published on Tue, 27 Mar 2012 06:00:00 UT Indexed on 2012/03/28 11:37 UTC
Read the original article Hit count: 220

Filed under:

A lot of people are storing large quantities of e-mail addresses in their systems. Since a large percentage of any system's user base is going to be supplying e-mail addresses from a few of the vastly popular providers (such as GMail and Hotmail), we are storing the "@gmail.com" and "@hotmail.com" parts of those addresses on disk over and over and over again.

SQL Backup Pro Get smart with SQL Backup Pro
Powerful centralised management, encryption and more.
SQL Backup Pro was the smartest kid at school.
Discover why.

© SQL Server Central or respective owner