Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Logged Operations


Logged Operations

Author
Message
UMG Developer
UMG Developer
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2280 Visits: 2204
Lynn Pettis (4/12/2011)
SanDroid (4/12/2011)
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;




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 and all the posts and see nothing regarding this code.

Please explain how this supports your position regarding the version store. You assert that this code supports your position, now prove it.


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 and leaves too much up to the reader. The definition for affect is: "have an effect upon", so in the quote "data affecting the version store" the "data affecting" part can refer to the data changed in the actual database not the data inserted into the version store. (Since it is the data that is affecting the version store.) And that data is logged. Of course the data actually inserted into the version store affects the version store as well. So I technically I think both interpretations are correct.

Disclaimer: I am not an English major, so I could be wrong. (It has been known to happen. :-))
SanDroid
SanDroid
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1414 Visits: 1046
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 and all the posts and see nothing regarding this code.

Please explain how this supports your position regarding the version store. You assert that this code supports your position, now prove it.

Lynn Pettis
--------------------------------------------------------------------------------


And that is where you and several others are so completely confused.

I have no specific assertion about the version store.
My assertion is that the three quotes in the first code are differant and state differant things.

Instead of responding to that assertion you keep demanding that I provide code to prove some other thing that you have yet to quote, refute, or provide any code to define.
Sorry I do not have any code for that. Hehe
Lynn Pettis
Lynn Pettis
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24200 Visits: 37964
SanDroid (4/12/2011)
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 and all the posts and see nothing regarding this code.

Please explain how this supports your position regarding the version store. You assert that this code supports your position, now prove it.

Lynn Pettis
--------------------------------------------------------------------------------


And that is where you and several others are so completely confused.

I have no specific assertion about the version store.
My assertion is that the three quotes in the first code are differant and state differant things.

Instead of responding to that assertion you keep demanding that I provide code to prove some other thing that you have yet to quote, refute, or provide any code to define.
Sorry I do not have any code for that. Hehe


You are correct, I am confused. What do the different values of the variables have to do with the version store? Please explain how these are related because I don't see it.

Cool
Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
SanDroid
SanDroid
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1414 Visits: 1046
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 and leaves too much up to the reader. The definition for affect is: "have an effect upon", so in the quote "data affecting the version store" the "data affecting" part can refer to the data changed in the actual database not the data inserted into the version store. (Since it is the data that is affecting the version store.) And that data is logged. Of course the data actually inserted into the version store affects the version store as well. So I technically I think both interpretations are correct.

Disclaimer: I am not an English major, so I could be wrong. (It has been known to happen. :-))


Thank you so much for that.
You think this would be clear to anyone that compared what was given with the provided reference. Especialy when the article referenced a specific type of version store and gave it a special name.

You are one of the few that get it.
The refference material and the statement made about it are different and use different words.

In my universe when you state your answer as A + B = a*b but your reference material and your work shows A + C = a*c then your answer is marked as incorrect.
SQLRNNR
SQLRNNR
SSC-Insane
SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)

Group: General Forum Members
Points: 21075 Visits: 18259
I really thought this dilemma was answered. Are we beating a dead-horse now?

If not, what exactly is the debate at this point?



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

SanDroid
SanDroid
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1414 Visits: 1046
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
Ignacio A. Salom Rangel
Ignacio A. Salom Rangel
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3114 Visits: 1439
CirquedeSQLeil (4/12/2011)
I really thought this dilemma was answered. Are we beating a dead-horse now?
If not, what exactly is the debate at this point?

I agree with Jason, what is the debate at this point?




My blog

TomThomson
TomThomson
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10709 Visits: 12008
CirquedeSQLeil (4/12/2011)
I really thought this dilemma was answered. Are we beating a dead-horse now?

If not, what exactly is the debate at this point?

At this point there is no point. And people talking past each other (instead of communicating) do not constitute a debate.

Tom

SanDroid
SanDroid
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1414 Visits: 1046
Tom.Thomson (4/12/2011)
CirquedeSQLeil (4/12/2011)
I really thought this dilemma was answered. Are we beating a dead-horse now?

If not, what exactly is the debate at this point?

At this point there is no point. And people talking past each other (instead of communicating) do not constitute a debate.

Tom,
Could not agree more. Not posting anything any more.
At first it was amusing, but this has become sad and is obviously distracting others.

Lynn,
as I stated in my first (private) message to you today please send me any real questions you may have in a private message.
Lynn Pettis
Lynn Pettis
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24200 Visits: 37964
SanDroid (4/12/2011)
Tom.Thomson (4/12/2011)
CirquedeSQLeil (4/12/2011)
I really thought this dilemma was answered. Are we beating a dead-horse now?

If not, what exactly is the debate at this point?

At this point there is no point. And people talking past each other (instead of communicating) do not constitute a debate.

Tom,
Could not agree more. Not posting anything any more.
At first it was amusing, but this has become sad and is obviously distracting others.

Lynn,
as I stated in my first (private) message to you today please send me any real questions you may have in a private message.


Couldn't agree more with Tom, Jason, et al. We are beating a dead horse and you won't defend and support your position in a manner that makes sense (yes, I'm still cofused as to your position).

Also, if this not worth debating in a public forum, I am certainly NOT going to debate it privately.

Cool
Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search