Viewing 15 posts - 4,096 through 4,110 (of 11,676 total)
What is this package doing in the log?
Could not load package "C:\Working\Ankit\Recons\Recon82\EBAR
December 4, 2013 at 6:02 am
What is the full output of the dtexec log?
December 4, 2013 at 3:39 am
Change it to DontSaveSensitive and try again.
December 4, 2013 at 2:20 am
What is the protection level of the package?
December 4, 2013 at 1:05 am
You have to switch the source and the target in your query.
December 4, 2013 at 12:54 am
If both source and target are on the same server, you could use the TSQL MERGE statement.
December 4, 2013 at 12:12 am
This question seemed so easy, I thought there was a catch 😀
(and it has been such a long time since I openened that component...)
December 4, 2013 at 12:06 am
Maybe you should enable error messages like the message says.
It will probably tell you the real reason.
December 3, 2013 at 12:33 pm
Evgeny (12/1/2013)
What is wrong with this answer?CREATE NONCLUSTERED INDEX IDX_A ON #temp1(a)
+1
Why is this answer "incorrect"?
Flawed question today, better luck next time 🙂
December 2, 2013 at 12:29 am
Maybe the production server has more contention for resources?
November 29, 2013 at 2:35 am
Easy one to end the workweek, thanks Steve!
Have a fine weekend y'all...
November 29, 2013 at 1:48 am
What if you rewrite the query?
DECLARE @Input INT = ?;
SELECT @Input;
Also make sure the property ByPassPrepare is set to True.
November 28, 2013 at 1:23 pm
Save the package and edit it with BIDS.
You can tweak the buffer settings and the BLOBTempStoragePath property to see if it gives additional gains.
November 28, 2013 at 7:03 am
Actual query plans of both situations might be nice to troubleshoot.
November 28, 2013 at 12:25 am
Viewing 15 posts - 4,096 through 4,110 (of 11,676 total)