Appreciate the question. Had to think for a minute, as I almost never use OUTER joins.

A totally unrelated aside: Back from vacation. Missed the QotD. Didn't miss work.

Spent 17...

Just from the first 2 lines of code, I knew this was a bitbucket question. 🙂

Thanks for the easy (now that I've researched the topic) point.

I doubt I will be...

I guess I was not yet awake enough to have gone for tempdb. I also was lucky enough to come across:

http://www.sqlservercentral.com/Forums/Topic846325-146-1.aspx

Regardless of wording, learned something. Thanks for the question.

(edited to...

Thanks for the question. Thought it was a trick for a minute. Then went with the obvious (to me) answer of one. IF you think about it, since the master...

L' Eomot Inversé (5/24/2012)

---

"computer science" question? Since when was T-SQL operator...

Thanks for the question. Mission accomplished for me = learned something.

Got stuck in meetings, so I wasn't able to get to QOTD until later than usual. But, I enjoyed the lively discussion.

Dredged up a lot of things I learned...

Thanks for the question Koen! IT was Monday before I saw it, so we'll call this an easy one for Monday. Glad to have a chance to learn about 2012.

bitbucket-25253 (5/17/2012)

---

So went and entered the code in SQL 2008R2, triple checked what I had entered and it matched what was given in the question. When pressing the F5...

Your...

sknox (5/17/2012)

---

I take issue with this option:

This is not always true (it depends on exactly where the corruption is), and...

Thanks for the question. Almost got it wrong due to speed reading wording about link-level consistency of BLOBS in the FILE SYSTEM. As others have mentioned, I knew I had...

Hugo Kornelis (5/16/2012)

According to this article[/url], you can check the current setting of SET XACT_ABORT by running SELECT 16384 & @@OPTIONS; - if the result is 16384, it is on;...

Hugo Kornelis (5/16/2012)The only way I can reproduce what you are seeing, both on SQL Server 2008 R2 (I don't have 2008 vanilla) and on SQL Server 2012, is by...

SQL Server...