Email Address

A Pattern for Email Address storage and retrieval

  • Article

Email addresses are very prevalent in IT systems and often used as a natural primary key. The repetitive storage of email addresses in multiple tables is a bad design choice. Following is a design pattern to store email addresses in a single table and to retrieve them efficiently.

4.39 (33)

2017-09-15 (first published: )

7,400 reads

Blogs

Updated Data Profiling in Power BI Desktop

By

In this month’s (October 2019) release of Power BI Desktop, they have added a...

Power BI Monthly Digest – October 2019

By

In this month’s Power BI Digest with Manuel Quintana [Blog | Twitter] and I...

Database Fundamentals #24: Filtering Data

By

If you’ve been reading these Database Fundamentals posts, you’ve already seen the WHERE clause...

Read the latest Blogs

Forums

More Network Restrictions

By Steve Jones - SSC Editor

Comments posted to this topic are about the item More Network Restrictions, which is...

More Computed Column Indexes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item More Computed Column Indexes

Using a Surrogate vs Natural Key

By steve@thesqlguy.com

Comments posted to this topic are about the item Using a Surrogate vs Natural...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers