Looking at why folks might be getting it wrong...

... Not everyone who uses SQL Server is a developer. I can imagine a lot of accidental dbas /...

<Cut> <Paste> <Execute> ?

Add one more to the list of people who answered 2, 0 for the reasons given.

I was just tickled that I knew the really correct answer this time, knew that...

So far, so good. This much XML I get. I'm also looking forward to the future steps, 'cause it's the manipulation, mutilation, and otherwise consumption of XML in...

2008, 2008 R2, or 2012... 😉

Doh! Don't tell my kids, I've been tormenting them with the word for months. (Thank you!)

Toreador (9/12/2012)

---

None of the options gave the expected order,...

Hugo Kornelis (9/10/2012)

---

Too bad that the explanation does not contain a link to the Books Online page that explains why this query fails - after all, from a performance perspective...

In fact, when I pull up the actual query plan SQL used for this CROSS APPLY,...

I missed the (0) too. I should have stuck with my first inclination, "Hey, there's no CREATE statements, so they'd all be errors..." *snap* 😀

Good question. Learned...

Now, had there been an option of "Table A will return 10 rows and Table B will return 7 rows" ... that could have been interesting.

Gotta admit, I kept poking at it, waiting for a gotcha. Contemplated fetching my coffee before I submitted my answer even....

So the correct answer is the Operating System limit.

Presumably, if I were to load SQL 2008 R2 Data Center Edition on Windows Server 2012... it would be able...

I pondered that, and tried to think of...

It's worse than that. The author said

It can...

I was afraid I was gonna go down in flames on this one 'cause I didn't want to include a NULL index (i.e. heap) in the mix. Turns out...