Thanks all for your reply, I have tried summarising the information into tables, but what I find out is that there are so many users who can run different kind...

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

  |--Assert(WHEREIf ([Expr1003]<'Aug 30 2006 12:00AM' OR [Expr1003]>='Aug 31 2006 12:00AM') then 0 else NULL))

       |--Table Insert(OBJECT[DB].[dbo].[CompanyProfile]),...

I will get the execution plan out to you in a minute. please bear with me

what what do you think about the indexes on the Ignore Dupe keys, I know thats where the problem lies, I am not sure if I am using the right...

Thanks for this, worked a treat

I hahve tried print screen, not working with the server, i really wanted to show you that nsert that took 1.30 hours.

But I just cant get the execution plan out,...

The last insert which I monitored via QA, its shown here graphically, not sure how i can send it.

As the code is withing a Cursor, I cannot use the code...

On the #ProfileTemp table, the date is likely to be all thesame, but at thesame time, converting to a char means that all dates will be covered.

eg: comparing 2006/09/04 to...

anytime i done a test run to see the execution plan, I does an index seek/Clsutered index seek.

The reason why: RTRIM(Convert(Char(10), p.SeizeDate , 112 )) = '20060830'

is there is because...

INSERT INTO DailyFeed' + @DateYYYYMMDD + '

        (

        tbMRFileStatus_id,

        CDRFingerPrint,

        EventType,

        StartDate,

        StartTime,

        UserProvCPN,

        RouteIg,

        RouteOg,

        CalledPN,

        CallingPN,

        ElapsedTime,

        ContCalledNum,

        CallRedirInd,

        CalledPNType,

        TelServInd,

        SwitchName,

        TypeOfCall,

        Termination_Date,

        Location_id,

       ...

I also forgot to mention, the table that its inserting into only has the Ignore Duplicate key, no clustered index or any other type of index.

The order by after the...

I changed this and even ordered the way the insert was done from the temp table. Still some isnerts take almost an hour and we are talking of less than...

The keys in question here, one is of a varchar data type which should always be unique, the other is of an int data type and the last one is...

There is need to do multiple inserts as different files needs to be loaded onto the database, we dont have any other replication method.

The datatime column is being converted so...

DDL

S_id   int

Event   int

UNIQUE_PERSONURN char

sDate   Datetime

alter table #temp add  constraint idx_pku Primary Key Clustered( SDate , Event , UNIQUE_PERSONURN)

Then Bulk insert happens in this order

1. Create #temp
2. Bulk insert into it
3. Add constraint above
4. Perform an insert into another...