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 » lessons learned   (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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement