Microsoft® SQL Server 2012 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

Performing vertical data partitioning ...