They are tantilizing are they not? The idea of having the DBMS store and maintain the materalized output of your view to disc sounds like it would be great. My experience however, has shown that they have very few real world uses. The restrictions on their creation makes them nearly usuable in most projects. You can't use Left Joins. You can't use Cross Apply. You can't use subqueries. You can't use Exists clauses and on and on and on... What is left are the most simplistic of queries in which you wouldn't consider using an indexed view in the first place!

I get that CruiseControl.NET is a free product and that dicates the type of support and user-friendliness you can expect. Yet, requiring developers to hack an XML file in order get their build is an awful user experience. Further, the messages you get when the CC Service cannot compile the ccnet.config file do not provide much information that can help you finish your work. I would have to believe the ThoughtWorks does not have many simultanous projects in CC.NET or they'd go crazy having to replicate source code control credentials. Either that, or they are cleverly hiding solutions from the rest us ;->.