Viewing 15 posts - 9,136 through 9,150 (of 13,881 total)
96,000 times round a Foreach loop sounds like a performance-killer to me.
It would be useful background to understand why you have decided to do things this way rather than...
August 16, 2014 at 4:29 am
I can't see a way of querying SSISDB directly to get this data. Which makes me wonder where SQL Server has put it!
But for those people who have adopted the...
August 14, 2014 at 1:28 am
Aha, OK - perhaps I should have considered that, thanks Chris. Sorry Alan.
I have reason to be picky - I'm building a WiX installer, so I'm in XML hell 🙂
August 13, 2014 at 5:19 am
I did part of this - I'm certain that you can work out the rest.
exec sp_MSforeachdb @command1 = 'use ?; select ''ALTER DATABASE ? MODIFY FILE ( NAME = N''+...
August 13, 2014 at 5:16 am
Alan.B (8/12/2014)
If I understand your question correctly you need to do what is referred to as a Left Anti Join Semi Join.
Not by me! Or anyone else, it seems....
August 13, 2014 at 4:46 am
There is another possibility.
Have two tables, t1 and t2, with identical structures.
t1 is your 'main' table. Assume that it is up to date with data.
On the next day, load table...
August 13, 2014 at 4:38 am
Is there any pattern as to when the query runs slowly? Could one of the servers be overloaded? Could some of the source tables be locked?
August 13, 2014 at 4:33 am
F/-\R//-\Z (8/12/2014)
hiI want Compare two Table data and insert changed field to the third table
who can help me
thanks a lot:-):hehe:
So all three tables have the same structure?
And...
August 13, 2014 at 4:31 am
ronan.healy (8/11/2014)
i have a tbale and after the table i want to put in a derived column that then pick just the data from the InvestmentType == "Forward Cash"
now i...
August 11, 2014 at 8:00 am
SQLTougherGuy (8/11/2014)
Thanks Phil - So what is the standard? Craigs code seemed to work.
Mine should execute slightly faster because there's no need for SSIS to go meta-data sniffing through the...
August 11, 2014 at 7:57 am
ronan.healy (8/11/2014)
a right ya sorry was getting mixed up.but the date has to be in the mmddyyyy for the system it goes into when the package runs
You mentioned...
August 11, 2014 at 4:46 am
Koen Verbeeck (8/11/2014)
Phil Parkin (8/11/2014)
ronan.healy (8/11/2014)
ok thanksand if the string is not all the same length I will probably hit problems ?
As long as the string is three or...
August 11, 2014 at 4:21 am
ronan.healy (8/11/2014)
ok thanksand if the string is not all the same length I will probably hit problems ?
As long as the string is three or more characters, you should...
August 11, 2014 at 3:11 am
ronan.healy (8/11/2014)
ok would you know any quick fix for this even a script or something to fix it
Create another derived column in 'YYYYMMDD' format and INSERT that instead.
August 11, 2014 at 3:10 am
m.mukesh.mca2009 (8/7/2014)
Hi, eID have only unique values but ID may have duplicate values
By being lazy and not providing what people are asking for, you are making this thread more painful...
August 8, 2014 at 12:07 am
Viewing 15 posts - 9,136 through 9,150 (of 13,881 total)