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)
8,671 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,724 reads
2014-11-04 (first published: 2014-10-06)
1,354 reads
Data Compression and Snapshot Isolation don't play well together, you may not see a performance benefit
2014-10-02
3,693 reads
SQL Server Database Migration Pitfalls (and How to Fix Them) Database migrations are where great...
Every Scooby-Doo episode has one thing in common — there’s always a fake ghost....
User Defined Functions is a new feature in PowerBI currently in public preview. There...
Several times now, I've seen a post asking for a solution. I've replied, and...
Comments posted to this topic are about the item Data > Hype
Comments posted to this topic are about the item Create and Read the Analysis...
What parameters are needed to enable a slipstream installation for setup.exe (SQL Server setup)?
See possible answers