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 » Indexed Views » OLTP » reporting   (RSS)
  • Mixing OLTP and reporting using indexed views

    I'm not a big fan of denormalizing, nor of repeating redundant redundant information in a database when those facts can already be derived from other information.  A classic example of the latter is when I see questions on newsgroups, forums or StackOverflow that ask how they can update a table's rank column to reflect the current rank based ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on December 29, 2009
Privacy Statement