title: Reliability of Indexed views
body: <p>I just found out that a report I quickly threw together years ago has been the sole means of collecting millions of dollars, and there isn't anything being done to check if it is correct.  </p>
  
  <p>For performance reasons, the report makes heavy use of indexed views.  This concerns me, since while I have used indexed views a lot, I tend not to use them for anything this critical.  </p>
  
  <p>Is it possible that the indexed views can fail to update or otherwise return information different from the data in the tables?  How real of a risk is this?  Is there a good SQL script I can run periodically to check for errors?</p>