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,997 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,696 reads
2014-11-04 (first published: 2014-10-06)
1,155 reads
Data Compression and Snapshot Isolation don't play well together, you may not see a performance benefit
2014-10-02
3,557 reads
By DataOnWheels
DIVERSIFY! We devote a lot of time to mastering the technology that we are...
By Angela-Henry
Have you heard the news about the new Power BI Project files? Okay, maybe...
By Steve Jones
I wrote an article that was published on SQL Server Central on how to...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers