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,314 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,660 reads
2014-11-04 (first published: 2014-10-06)
1,089 reads
Data Compression and Snapshot Isolation don't play well together, you may not see a performance benefit
2014-10-02
3,403 reads
Creating a custom container is where things get truly exciting. There’s actually a ton...
By Brian Kelley
I’ve seen this more and more over the last year: I receive a phone...
Speaking at SQLSaturday Dallas! I’m proud to announce that I will be speaking at SQL...
Comments posted to this topic are about the item The Change Failure Rate
I have reporting server which gets replicated from other OLTP server.However, the reporting server...
While analyzing an issue, I stumbled on to a "FlushCache" error message (error log). ...
Ask SSC