ronmoses (6/25/2012)

---

On the contrary, I think that's exactly the kettle of fish the question asks about. "A Table Variable can have primary keys and indexes defined." I don't...

sestell1 (6/25/2012)

---

I was always under the impression that there was no reason to create indexes on table variables because they exist only in memory.

Does anyone know what SQL Server actually...

Hugo Kornelis (6/25/2012)

---

When I answered the question, I *knew* I was taking a gamble on the intended interpretation.

What convinced me to pick the "wrong" answer was the wording: "can have...

+ yet another one to what has gone before.

I reckon the only right answer is 1,2,3 and 4, unless the question meant "all the updates of which transactions" in which...

rodjkidd (7/19/2012)

---

Enjoyed The Hobbit.

Did get a little stuck with LOR, but worth it in the end.

Haven't read any other Tolkien books though.

Ran through the first three Dune books, took a...

misguided post erased

Toreador (6/27/2012)

---

That's exactly the basis on which I answered "None unless the rest of the statement creates one", which...

Toby Harman (6/26/2012)

---

You have two answers that are potentially correct here.

None, and None unless the rest of the command specifies one.

Shame I picked the wrong one!

Edit: I stand corrected. The...

+1. Hugo on form as usual.

Like those who commented earlier, I think both options work (provided there was a clean shutdown). I picked the second because although I knew the first optioopn would also...

David P Fisher (6/21/2012)

---

tommyh (6/19/2012)

---

If one wants be really picky "Depends on File System" is actually the right answer.

You can install 2012 on FAT32 and that have a limit...

Rich Weissler (6/20/2012)

---

That just reminds me of one of my favorite quotes from my childhood. "640K ought to be enough for anybody." (Even if folks deny ever saying...

I'm always optimistic about backwards compatability too, and if I had been often let down I would have changed to pessimism....

Nice easy question.

But obviously batch 1 works, and batch 2 can't work (because the table is dropped by the exit from exec), and only one of the answers...

An allusion