Viewing 15 posts - 3,451 through 3,465 (of 5,393 total)
Did you compare the actual execution plans? Can you post them?
Can you post table and index definition for all the tables involved?
You may also take a look at this article...
-- Gianluca Sartori
February 18, 2011 at 1:11 am
The variables you are using inside OPENROWSET have to be declared and initialized inside the same code block (in other words, inside the string you are using as argument). It...
-- Gianluca Sartori
February 17, 2011 at 4:05 pm
GilaMonster (2/17/2011)
Koen Verbeeck (2/17/2011)
Gianluca Sartori (2/17/2011)
Code brings more (pseudo)code, it seems...Definitely kill the one who started this on THE THREAD!
:-D:-D
I'll go fetch the angry mob! 🙂
There's a few of them...
-- Gianluca Sartori
February 17, 2011 at 2:40 am
CirquedeSQLeil (2/16/2011)
For the execution of Wayne:
--get spid of code requestor
sp_whorequestedcodeIntheThread 'Wayne'
--use returned spids to verify the request
dbcc inputbuffer(61)
--output
'Wayne definitely requested code on the thread'
--yup that's the one
Kill 'Wayne'
Craig...
-- Gianluca Sartori
February 17, 2011 at 1:01 am
DBA-640728 (2/16/2011)
OLE DB provider "SQLNCLI" for linked server "(null)" returned message "Deferred prepare could not be completed.".
Msg 8180, Level 16, State 1, Line 1
Statement(s) could not...
-- Gianluca Sartori
February 17, 2011 at 12:55 am
Jeff Moden (2/14/2011)
GilaMonster (2/14/2011)
Another promising looking contract cancelled due to lack of @#$$#@$%$ budget!
I'm almost at the point of walking away and going to work in a book store...
-- Gianluca Sartori
February 15, 2011 at 1:05 am
It could also be that your procedure plan was compiled against stale statistics and then cached.
Did some index/statistics maintenace run meanwhile?
-- Gianluca Sartori
February 11, 2011 at 10:44 am
I spent the last 2 days investigating the issue and I found something really interesting.
BOL states that updating statistics causes queries to recompile:
UPDATE STATISTICS:
-- Gianluca Sartori
February 11, 2011 at 9:34 am
I must have missed it the first time it was published.
Smart and interesting. Well done.
I will probably never use it for all the reasons that others have pointed out.
-- Gianluca Sartori
February 11, 2011 at 5:52 am
ALZDBA (2/9/2011)
that auth remark rings a bell.If I recall correct our DB2 (udb gateway for z/os) admins granted read on the IBM folder (and subsequent folders) to authenticated users.
Interesting note,...
-- Gianluca Sartori
February 10, 2011 at 12:56 am
Hi everyone.
Here's how things evolved meanwhile:
1) It's not a distributed transaction issue. It was initially, then I configured MSDTC correctly and it started giving the same error for a different...
-- Gianluca Sartori
February 9, 2011 at 9:20 am
Thank you, Jeff. I will try and keep you posted.
-- Gianluca Sartori
February 9, 2011 at 7:59 am
Tom.Thomson (2/9/2011)
Gianluca Sartori (2/9/2011)
You're looking for the MERGE statement, I guess.EDIT: clicked the wrong button.
As the two inserts and the update are on three different tables, and when the target...
-- Gianluca Sartori
February 9, 2011 at 6:45 am
MysteryJimbo (2/9/2011)
You can get the plan_handle using this....
Thank you, Jimbo. I know how to retrieve the query plan, what I can't predict is whether it's going to be good or...
-- Gianluca Sartori
February 9, 2011 at 6:21 am
Viewing 15 posts - 3,451 through 3,465 (of 5,393 total)