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 ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.