• Quote: "Excellent article, however, I'm sure the value of indexed views can be communicated just as effectively without preaching to us about denormalization...which seems to be the author's real point of contention. "

    Actually, the author is specifically using indexed views as an alternative to denormalizing the base tables.  The use of indexed views as a way to bring about the same effect as denormalizing is an awesome technique if it works as described (which I'm testing right now).

    Rock on, three points awarded to sanity's side.

    cl

     

    Signature is NULL