Jeff Reinhard


SQLServerCentral Article

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)

You rated this post out of 5. Change rating

2017-09-15 (first published: )

8,651 reads

Blogs

The PASS Summit on Tour in Dallas

By

The PASS Summit goes on tour this year, with a September stop in Dallas....

SQL Server Auto-settings: The Good, the Bad, and the Ugly

By

Settings That Could Be Hurting Your Performance If you’ve ever created a new SQL...

Bad Request Error when Running PowerShell Command in Azure Devops

By

I needed to run a PowerShell cmdlet in an Azure Devops pipeline. The cmdlet...

Read the latest Blogs

Forums

How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory

By Chandan Shukla

Comments posted to this topic are about the item How a Legacy Logic Choked...

Upgrading from 2012 to 2022

By cajun_sql

Hi, Would it be possible to upgrade from sql server 2012 sp4 to sql...

Has the PK been used --

By dbakevlar

Comments posted to this topic are about the item Has the PK been used...

Visit the forum

Question of the Day

Has the PK been used --

You're analyzing a query execution plan in SQL Server to determine whether the query optimizer chose to use a primary key index. Which Dynamic Management View (DMV) would you use to verify the usage of the primary key in the plan?

See possible answers