Great question, Lokesh. Even though I haven't wet my feet in SQL Server 2012 yet, it is good to learn beforehand. Keep them SS2K12 coming!!

Saludos,

With the wind?

Confusing question. I got it right because I decided to go with the results of the estimated execution plan instead of the actual, but I agree the wording and explanation...

realistic

Great question. Didn't know some DDL could/couldn't be used within a transaction. Good to learn something new. Thank you, Lokesh.

Nice question, learned something new today.

Good back-to-basics question.

joe.wolfe (9/13/2012)

---

The given answer to this question is "true", but I am not sure this is correct. The "NotGo" throws an error "Incorrect syntax near 'NotGo'" and the variable

RBarryYoung (9/13/2012)

---

EL Jerry (9/12/2012)

---

Barry,

I noticed you can do HTTP downloads from this site, but can you do FTP downloads from this site? I was able to FTP connect...

Kenneth.Fisher (9/13/2012)

---

FYI In case anyone is interested you can change the batch seperator (and other settings) on a single query window by right clicking on the window and going to...

Sean Lange (9/13/2012)

---

honza.mf (9/13/2012)

---

Sean Lange (9/13/2012)

---

Good question.

For everybody who seems to be hung on the verbiage I can only say "GET OVER IT". English is not the native tongue of...

Hugo,

As usual, thank you for the BRILLIANT and detailed explanation on this topic. I found your point #3 most...

Barry,

I noticed you can do HTTP downloads from this site, but can you do FTP downloads from this site? I was able to FTP connect to

Good question, though I'm still having a hard time trying to understand collations.

Great question. I didn't research enough regarding clustered index and non-empty table, so I got it wrong this time. Learned something new.