Viewing 15 posts - 8,776 through 8,790 (of 13,882 total)
I hope that this was a test migration rather than a "fingers-crossed-and-hope-for-the-best" migration;-)
We had some performance problems too. You may find this thread interesting. Or at least relevant.
I have not...
January 19, 2015 at 10:33 am
I don't understand much of what you have written, but perhaps this helps?
January 19, 2015 at 1:10 am
carpay (1/17/2015)
January 18, 2015 at 1:36 am
J0shu@ (1/16/2015)
A higher level question with regards to implementation strategy. When implementing a SSIS package, should the priority of process be put on the SSIS side as much as...
January 18, 2015 at 1:32 am
J0shu@ (1/16/2015)
I am working on the alterations suggested by Nevyn. The folder descriptions are integer ID's, incrementing from 1~2500. Also, each folder has 200 files which are also integer...
January 16, 2015 at 8:39 am
Nevyn has provided you with some good advice here, I agree with everything he has written. I'm sure that we can find you some links on setting up parallel FELs...
January 16, 2015 at 12:37 am
krypto69 (1/15/2015)
I'd prefer to do it all in SSIS, but it's not a requirement.
Is there a way to do use an external file splitter and call it from...
January 16, 2015 at 12:26 am
Do you have to do this in SSIS, or could you create the (big) file as usual and then use some other tool to split the file? Are the files...
January 15, 2015 at 12:29 pm
Prudhvi _SQL (1/15/2015)
SELECT CAST(CAST(datefield AS DATE) AS DATETIME)FROM datetable
Why stop there?
How about
select cast((stuff(stuff(convert(char(8), datefield, 112), 5, 0, '-'), 8, 0, '-')) as datetime)
?:hehe:
January 15, 2015 at 12:24 pm
Try:
Select dateadd(day, datediff(day, 0, datefield), 0) as datefield
from datetable
Hope this helps.
Same execution plan for my solution, though yours does return the zero time component & is therefore a more...
January 15, 2015 at 10:09 am
TSQL Tryer (1/15/2015)
2013-05-10 08:15:24.000
I want it to just return - 2013-05-10 00:00:00.000, so the time...
January 15, 2015 at 9:45 am
Has the column IDENTITY() definition changed in the table's DDL?
January 15, 2015 at 4:31 am
I probably made this a little harder than what it could have been
Let me remove any doubt: yes you did! 🙂
But it works and that's great. Should you decide...
January 15, 2015 at 12:13 am
sm_iransoftware (1/14/2015)
We need to run Always on , on our sql servers.
Is there any upgrade or benefits on sql server 2014 about Always on ?
Or
Should I Upgrade to 2014...
January 14, 2015 at 5:23 am
Just a standard FOREACH loop should be sufficient for this.
If you configure the FEL something like this[/url], you will see that, for every file processed, the full file path can...
January 14, 2015 at 12:18 am
Viewing 15 posts - 8,776 through 8,790 (of 13,882 total)