SanDroid (4/12/2011)

---

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 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.

Please explain how your code supports your position. All I see is a union of 3 selects of a literal value based the comparison of two variables.

My position is that the three variables will never be equal to each other, but the QOTD answer is only correct if they do.

I await any explination as to why these three variables where submitted as being equal.

If you have some code you can post that that show these three values taken from the QOTD material are equal and have the same meaning, please post it. I did have an example that used soundex but I have seen that function give a false positive in the past.

If you feel like posting more questions about what I am stating, please provide a code example.

Remember, it is up to you to provide code to back up what you are trying to say.