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 » Denormalization   (RSS)
  • Denormalize with consciousness (aka Constraint are not an option)

    Today I had to help a customer to make their upgraded invoicing system to work correctly…and as quite often, the source of the problem was a bad denormalization. From now on, each time I can do it without revelaing too much of the customer, I’ll try to write a post so to it will be clear to anyone (developers in particular) what are the dangers ...
    Posted to Davide Mauri (Weblog) by manowar on August 2, 2010
  • 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