Microsoft SQL Server 2014 Unleashed

Essential Denormalization Techniques

You can use various methods to denormalize a database table and achieve desired performance goals. Some of the useful techniques used for denormalization include the following:

Keeping redundant data and summary data

Using virtual columns

Performing horizontal data partitioning using multiple tables rather than table partitioning

Performing vertical data partitioning

Redundant Data

From an I/O standpoint, joins ...