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: 226
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