Viewing 15 posts - 3,451 through 3,465 (of 5,394 total)
Last year I went to an Oracle Exadata presentation. They say the future for DBAs will be plugging ethernet and power chords. 😛
February 18, 2011 at 1:13 am
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...
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...
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...
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...
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...
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...
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?
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:
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.
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,...
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...
February 9, 2011 at 9:20 am
Thank you, Jeff. I will try and keep you posted.
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...
February 9, 2011 at 6:45 am
Viewing 15 posts - 3,451 through 3,465 (of 5,394 total)