Good question, thanks.

It have the book and I agree it is a great book, but the answers to the question were a little misleading I thought.

GilaMonster (11/19/2009)

---

Cliff Jones (11/18/2009)

---

The Tuning Adviser often recommends that a column which is also a part of the Clustered index be added as an included column. I do not...

Good question which reminds me of something similar. The Tuning Adviser often recommends that a column which is also a part of the Clustered index be added as an...

I agree, a great series of articles explained in a way that is easy to understand. Gail, thanks for taking the time to put this together.

Lynn Pettis (11/17/2009)

---

Cliff Jones (11/17/2009)

---

I work with date time functions all of the time and would contend that since the Time Zone is not returned as part of the result,...

As a practicle matter, I would never win that argument with my clients.

I work with date time functions all of the time and would contend that since the Time Zone is not returned as part of the result, the times are different....

I agree, nice question. I learned something new today and that is the point.

No problem, it is just a fairly easy point for Veterans Day.

Ok, thanks for the reply. It doesn't work like I thought it did and apparently we just didn't get bit by it on our SQL 2005 migration. ...

That is what I am trying to prevent but leaving the...

One of the issues was with the new Date and Time datatypes. Even though the database was set to SQL 2005, it allows the developer to use these new...

Otherwhise it was a good question though.

geervani (9/24/2009)

---

The answer for the question is YES. FROM clause can be used in UPDATE query. But the example query given is wrong.

something like this will work

update table1

set ...