We're talking 46 seconds v 38 seconds, not a huge amount at all. Both of the timings are averaged out from several runs.

They are both being stored in a...

Hi Chris

Absolutely identical on every row.

Hi Chris

I've had a look at the updated Splitter code and it actually runs a few seconds slower than my original.

Not entirely sure why as I would have thought it...

Thanks Chris

I'll have a look at the updated Splitter code and let you know the outcome.

As for the second part, I'm storing what is effectively a number (e.g.20160630 for today)...

Hi Chris

That was just a code snippet, here's the complete query:-

set dateformat dmy

declare

@start datetime

,@end datetime

set @start=cast(DATEADD(month,-2,getdate())-DATEPART(d,getdate())+1 as date)

set @end=cast(DATEADD(month,-1,getdate())-DATEPART(d,getdate()) as date);

INSERT INTO [MDS_Maternity].[dbo].[MAT401Induction] (

[LocalPatientIdMother]

,[LabourOnsetDateTime]

,[LabourInductionMethod]

,[OxytocinAdministeredDateTime]

,[ReportingMonth]

)

SELECT distinct

LocalPatientIdMother = ad.UnitNumber

,[LabourOnsetDateTime] = cast(

dateadd(minute,cast(right(q2.TimeofOnsetofLabour,2) as...

Thanks Chris

I've now got it running as expected.

Hi Chris

Thanks for that.

So I'd just just APPLY/LEFT JOIN as normal?

As for the linked server, I have to for now.

We're upgrading some servers to SQL2012 and then going to use...

13.0.1800.19

Thanks for that Jeff.

I'll have a chat with the SAN admins and see where our drives are sat.

@frederico - we did have a think about the load balancing option by using some sort of load table to pick up the next available file but couldn't quite figure...

Hi Jeff

If only......

We get the CSV files as a data extract (I haven't got a clue what format the back end of the application runs on).

This is also a national...

The files contain different data (and headers) and are loaded via a BCP routine.

The targets are also dealt with in a similar fashion (the target SQL table is starts tbl...

Hi Phil

Yes, each file goes into its own table and is further processed by SQL separately.

@john-2 - we can't add any indexes at all to any of the tables as it's a 3rd-party app that pushes its data through to SQL. The only thing...

@hugo - I've tried clearing the plan cache and then running the code again but it was still giving me the same issue.

I can run the basic SELECT or the...