Yep, Ajas, that's the one. It's a SERIOUS drain on most servers (for reasons
I elaborate on in the resources I linked to). So yes, if you do use the
client.lastvisit variable, you will want to seriously consider how valuable
it is and whether you might get value doing it otherwise.
/charlie
Ok, but to be clear I really was only discussing the technical aspect. I'm
not sure what all the other observations brought to that part of the
discussion. My bottom line point was not to argue against your use of client
variables. I suggested a reason why one may choose to do it and yet treat
Thanks Charlie for confirming that setting.
Do you want to know where I learned that? The answer is : From Mr. Super
Charlie Arehart. Thanks. :-)
Ajas Mohammed /
http://ajashadi.blogspot.com
We cannot become what we need to be, remaining what we are.
No matter what, find a way. Because thats
Come on Charlie, don't be so humble. You're one of the community stars, and
have been for years. Revel in some kudos for a moment...
From: Charlie Arehart char...@carehart.org
To: discussion@acfug.org
Sent: Tue, January 26, 2010 11:22:46 AM
Subject: RE: [ACFUG
Hi Greg,
I found the stored proc which results in deadlock situation. It has lets say
about 10 updates like this
update tbl set col3 = someval where col1 = @col1 and col2 = @col2
update tbl set col4= someval where col1 = @col1 and col2 = @col2
update tbl set col5 = someval where col1 = @col1
Hi Ajas:
It may be helpful to see a section of your stored procedure code that is
doing the updates. Also, approximately how many records are in each of the
tables being updated and approximately how many records are being updated?
The SQL engine or optimizer may behave differently depending on
Hi Greg,
I will try to answer to the best of my knowledge.
There are 407359 records in the table. There is only 1 record being updated.
Not sure if its full table is being locked or not.
Do you have the ability to analyze the actual statement to get an execution
plan?
Well, let me see if I
Oh, alright Shawn. Fine! :-)
And Derrick, “we cool”. Was just clarifying, too. :-)
/charlie
From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of shawn gorrell
Sent: Tuesday, January 26, 2010 11:29 AM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] Ideal memory Configuration
You can copy one of the update statements that you are using inside the sproc
(stored procedure) into the query analyzer and see the execution plan for the
update query. If the columns of the WHERE clause is in an index see if than
index is being utilized in the execution plan.
Also, do you
