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.
2017-09-15 (first published: 2015-09-24)
7,791 reads
A brief introduction to the sparse option and script to help decide when to use it
2016-08-25 (first published: 2015-04-10)
1,691 reads
2014-11-04 (first published: 2014-10-06)
1,137 reads
Data Compression and Snapshot Isolation don't play well together, you may not see a performance benefit
2014-10-02
3,479 reads
New blog post - Architect a disaster recovery for SQL Server on AWS: Part...
New blog post - Seamlessly migrate large SQL databases using AWS Snowball and AWS...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
I'm pretty new a creating JSON output form SQL server. I'm having trouble with...
I'm looking for some suggestions on how to create a delta file that will...
Hi, I've found several examples using dm_exec_procedure_stats but the results are only useful as...
Ask SSC