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 t-logs (yes, there is a way to read the logs). Post the code and your results. Posting the code allows others to verify your results, to experiment with other alternatives.

To paraphrase an old saying, "Code talks, BS walks."

You are correct. I should have provided something that proved what I was stating was correct.

I have no hard data from a DMV, but I think this is clear enough.

Declare @quote1 varchar(max)

,@quote2 varchar(max)

,@quote3 varchar(max)

SET @quote1 = 'Data affecting the version store' -- QOTD Answer;

SET @quote2 = '"Inserts" into the version store' -- QOTD Answer explination;

SET @quote3 = '“insert” into the Append-Only store' -- QOTD Answer refernece;

SELECT 'X' where @quote1 = @quote2

union

SELECT 'X' where @quote2 = @quote3

union

SELECT 'X' where @quote1 = @quote3;

I know that the above code will never return any value or result other than "(no column name)".

Other people told me it does, and others are telling me that this code does not execute.

I asked for this to be explained. It was not the first thing I asked, but it is where it ended up.