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,438 reads

Blogs

Power Platform Quick Tips – Episode 03: Documenting Power Automate Flow Logic

By

Welcome back to my series on Power Platform quick tips! In this episode you...

State of Database DevOps Survey

By

Maybe you’re using DevOps within your database development and deployment. Maybe you’re not. Maybe...

HP is the 2019 Laptop Winner

By

This is for me, not necessarily for you, but I decided to go with...

Read the latest Blogs

Forums

Log Shipping - What has changed

By nwood2009

We currently have a situation with a vendor where they will only give us...

Rebuild vs Reorganize

By sergey.gigoyan

Comments posted to this topic are about the item Rebuild vs Reorganize

Increase Query Speed with Covering Indexes

By steve@thesqlguy.com

Comments posted to this topic are about the item Increase Query Speed with Covering...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers