THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Normalization » data modeling   (RSS)
  • Denormalize for Performance?

    Conventional wisdom says to “normalize to 3rd normal form then denormalize for performance.” Poppycock! I say for an OLTP operational database (not a reporting or BI database), a well normalized design will outperform a denormalized design for three good reasons: 1)      If the denormalization duplicates data, then the ...
    Posted to Paul Nielsen (Weblog) by Paul Nielsen on October 3, 2008
Privacy Statement