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: 232
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.
![]() |
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