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
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 4, 2013 at 6:02 am
What is the full output of the dtexec log?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 4, 2013 at 3:39 am
Change it to DontSaveSensitive and try again.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 4, 2013 at 2:20 am
What is the protection level of the package?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 4, 2013 at 1:05 am
You have to switch the source and the target in your query.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 4, 2013 at 12:54 am
If both source and target are on the same server, you could use the TSQL MERGE statement.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 4, 2013 at 12:06 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 4, 2013 at 12:04 am
Maybe you should enable error messages like the message says.
It will probably tell you the real reason.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 2, 2013 at 12:29 am
Maybe the production server has more contention for resources?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 29, 2013 at 2:35 am
Easy one to end the workweek, thanks Steve!
Have a fine weekend y'all...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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.
Data Flow Performance Features
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 28, 2013 at 7:03 am
Actual query plans of both situations might be nice to troubleshoot.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 28, 2013 at 12:25 am
Viewing 15 posts - 4,096 through 4,110 (of 11,676 total)