Jeff Reinhard

A Pattern for Email Address storage and retrieval

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

Blogs

Azure Platform Series: How to setup Azure Cloud Shell

By

This blog post will be a series on the Azure Platform and some things...

Daily Coping 5 June 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Use Chocolatey to Install Multiple SQL Server 2019 Instances for Testing

By

I’m working on a project where it’s useful to automate environment setup and teardown...

Read the latest Blogs

Forums

Attach and Detach Method vs SQL Manage object method

By Nusc

Hi there, if you want to detach a database you would right click on...

How to generating Excel File with multi sheet by using SQL server 2012?

By ahmed_elbarbary.2010

I need to create stored procedure or query or any thing on SQL server...

performance tuning for a subquery

By rohitkocharda

Hey Guys I have a quick questions regarding a better way to write a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers