Lynn,

Sorry I put so many words in my last response.

Here is the important part again.

I have no specific assertion about the version store.

Do you have any other questions? :hehe:

UMG Developer (4/12/2011)

---

Lynn,

I pointed out what I think SanDroid was trying to say in this post: http://www.sqlservercentral.com/Forums/FindPost1090218.aspx

I think this is one of those cases where the English language is imprecise...

You still haven't proven your point. I still see nothing in the code above that supports your position regarding the version store. I have also gone back through the QotD...

Lynn Pettis (4/12/2011)

---

SanDroid (4/12/2011)

---

Lynn Pettis (4/12/2011)

---

Bottom line, your stating your interpretation of the support information isn't enough. Support your position with code, hard data from the DMV's, output from...

Lynn Pettis (4/12/2011)

---

Bottom line, your stating your interpretation of the support information isn't enough. Support your position with code, hard data from the DMV's, output from t-logs (yes, there...

GilaMonster (4/12/2011)

---

I noticed nothing wrong with the question or answer, nor have I implied as much anywhere in this thread. In fact you are the only person complaining. Piquet simply...

Steve,

Great article and wonderfull graphic.

One question I have always had about this new Policy of least privilidge that M$ started pushing for in XP is this.

Are internall or...

Wayne, you are right. I really wanted...

Lynn Pettis (4/7/2011)

---

For the record, I missed this one too.

I also found SanDroid and his arguments most interesting, if not totally off in left field somewhere. It is annoying...

GilaMonster (4/12/2011)

---

Piquet (4/12/2011)

---

Umm - there are TWO correct answers listed for this question (as described in the explanation), but only ONE can be selected. i.e.:

- Inserts into Table Variables are...

Ignacio A. Salom Rangel (4/7/2011)

---

I personally like the way SanDroid persist until he got the answer he was looking for(a bit to eager :-P), but we should all be eager...

Tom.Thomson (4/7/2011)

---

Yes of course they are written to the transaction log file; I can very easily write a bunch of programs to declare and initialise hordes of table variables and...

GSquared (4/7/2011)

---

Again, NONE of that is the data in the version store. That's data...

FYI, Paul has responded (via Twitter):

"Tell them I said all vstore activity is...

Stefan Krzywicki (4/7/2011)

---

So to clarify your position, because you don't think anyone else has shown evidence that convinces you the QOTD is correct, you don't feel the need to show...