Thanks for the link

Vimal Lohani (8/18/2014)

---

XML Queries may be yuck,

But you have to prepare this for 70-461, 8 to 10 question comes...

Vimal Lohani (8/18/2014)

---

XML Queries may be yuck,

But you have to prepare this for 70-461, 8 to 10 question comes...

Good question. Thanks

Good question, Tom. Thanks!

This is a good example of how things can go wrong when using this syntax.

It's a good question. Learned something today.

Actually, if you run the script as is it will not even rename the object.

Since it is lacking a GO statement between the...

+1. Thanks.

By the way, this also works the same in 2008 R2.

Thanks, Hugo.

Good follow-up to the previous question.

TomThomson (8/5/2014)

---

Nice simple question. The only difficulty was remembering what release the feature was introduced in, 2008 or 2008R2, and then I remembered which release Neos was upgrading to...

Good question, Hugo. Thanks!

Thanks for the question.

I came across this fact just yesterday so I had it fresh in my mind 😀

Good question.

+1.

Hmmm... Learned something today.

Good question. Thanks!

GilaMonster (7/25/2014)

---

robert.diley (7/25/2014)

---

I was a D fan myself.

Then I looked at the query plan for the example in the TechNet article at http://technet.microsoft.com/en-us/library/ms187638(v=sql.105).aspx. What it shows (at...

I also chose D as the answer.

The whole point of a correlated subquery is that the inner query depends on information given to it by the outer query to yield...