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.

---

quote:

---

See, I did change the title!

---

Yes, I see, but didn't post, because I don't want to sound picky again

Frank
http://www.insidesql.de
http://www.familienzirkus.de

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

I am confused about what can and can't be done with SQL Server Standard Edition. I have Standard Edition and want to turn some of my existing views into indexed views if it will increase the performance of selects against them.

Is this possible?

PRB: Indexed Views Can Be Created on All Versions of SQL Server 2000

http://support.microsoft.com/kb/270054/en-us