SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Jeff Reinhard

SQLServerCentral.com profile

   Items 1 to 2 of 2   
 

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.  Read more...
By Jeff Reinhard 2015/09/24 | Source: SQLServerCentral.com | Category: email address
Rating: |  Discuss |   Briefcase | 5,814 reads

Data Compression and Snapshot Isolation

Data Compression and Snapshot Isolation don't play well together, you may not see a performance benefit  Read more...
By Jeff Reinhard 2014/10/02 | Source: SQLServerCentral.com | Category: data compression
Rating: |  Discuss |   Briefcase | 3,380 reads
   Items 1 to 2 of 2