SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Logged Operations


Logged Operations

Author
Message
UMG Developer
UMG Developer
SSCertifiable
SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)

Group: General Forum Members
Points: 7224 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
SSCarpal Tunnel
SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)

Group: General Forum Members
Points: 4624 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 Guru
SSC Guru (223K reputation)SSC Guru (223K reputation)SSC Guru (223K reputation)SSC Guru (223K reputation)SSC Guru (223K reputation)SSC Guru (223K reputation)SSC Guru (223K reputation)SSC Guru (223K reputation)

Group: General Forum Members
Points: 223311 Visits: 40400
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
SSCarpal Tunnel
SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)

Group: General Forum Members
Points: 4624 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 Guru
SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)

Group: General Forum Members
Points: 143985 Visits: 18651
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
Learn Extended Events

SanDroid
SanDroid
SSCarpal Tunnel
SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)

Group: General Forum Members
Points: 4624 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
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12992 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

Tom Thomson
Tom Thomson
SSC Guru
SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)

Group: General Forum Members
Points: 50529 Visits: 13157
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
SSCarpal Tunnel
SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)

Group: General Forum Members
Points: 4624 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 Guru
SSC Guru (223K reputation)SSC Guru (223K reputation)SSC Guru (223K reputation)SSC Guru (223K reputation)SSC Guru (223K reputation)SSC Guru (223K reputation)SSC Guru (223K reputation)SSC Guru (223K reputation)

Group: General Forum Members
Points: 223311 Visits: 40400
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