Roy Ernest (7/28/2009)

---

john.arnott (7/28/2009)

---

Just be careful of starting an internecine battle. There are more of...

Yes it is possible. I would not suggest it.

Andrew Collins (7/28/2009)

---

Does anyone know how much this costs? i cant seem to find a price anywhere (UK Price)

Do you need a separate license for a passive node on a...

Thank you, Lutz.

Well, it is now official. We are down one daughter in our household.

Kassondra is now on her way to Fort Jackson in South Carolina to start her military career...

michael vessey (7/27/2009)

---

ok - let me be clear

the original post indicated that i wanted an Efficient method of getting the max value from Rown_number()

but the query inside the CTE/subquery...

Here is part of your problem, your code:

CASE

WHEN @ProgramCode = '01' AND

@CovII >...

Based on the original sample using only one table, yes, your requirements changed.

Going to more complex queries, it may have helped to show that instead of a single table query,...

Hima Bindu Nagisetty (7/26/2009)

---

It looks like indexed views do use their index without NOEXPAND option on Developer edition too.. Please try below test script.

The execution plans for last two statements...

Because, WS_Job_Number is defined as [char](17) and ProjectId is defined as an int, therefore I wanted...

mosl31 (7/26/2009)

---

Not to be a nit-picker Lynn, but Brad did specifically refer to religion.

"People of faith, participating in their chosen religion."

For many people you can't have one without the other,...

Slick84 (7/26/2009)

---

So how about a DBA who does not possess those qualities and does not qualify the criteria you have laid out? What's wrong with them? If I'm reading your...

mosl31 (7/26/2009)

---

I would agree with all except the last one. I don't think DBA's are more religious than anyone else. Probably they are more like a typical scientist who is...

What is the performance of your...

Jeff Moden (7/24/2009)

---

Lynn Pettis (7/24/2009)

---

.,.,., why not let Jeff post the url? Others, like myself, may just benefit ... oh, you want to keep us in the dark, like...