Sounds as though the IMEX flag might be a concern.

However, I believe that is only for Excel files, based on some reading

I'm using the text driver (due to this file...

I definitely agree and appreciate the response.....

However, my situation is that they are 'telling me' to use OPENROWSET even after numerous discussions.

However, it does not work when the numbers are...

I'm guessing the obvious indexes have been configured.  Can you determine anything from the execution plan as to why this is happening?  OR is not great performance, but I see...

Try these 'network' troubleshooting ideas:

1.  Try to connect by IP if you are connecting by 'name' now.

2.  Ping the IP and hte name to ensure both are returning in sufficient...

Generally, this is more complex than just adding a file group.  The rule of thumb I would use, if, for performance, you need to add more then do it.  Meaning...

The clear text logs spoken about earlier can be found in the LOG directory under the MSSQL directory in your installation path.

Always remember to check the event logs as well. ...

I did something 'sort of' like this.

I profile and then suck that file into a table on a different server.

then I have a table with all the procedure names.

I join...

My experience is simliar.  However, did you see a sudden increase in the time to complete the job?  Can you space out your reindexes by changing fill factors?  My experience...

Yes, I think it is hanging at that select.

This particular line really concerns me.

Table 'Prestatie'. Scan count 1, logical reads 14694, physical reads 0, read-ahead reads 0.

It menas in the...

To answer an above question, no you cannot use an ordery by clause IN  a view...but ON  a view you can.

Additionally, I think this is pretty straight forward.

Unions listed should...

I think it means paused.

Right click on the server, and click 'start' to see if it goes away.

If you run JUST the update query, what is the resultant time to run?

What is the results of SET STATISTICS IO ON.

Being its a primary key, I'm assuming its also...

While I'm looking at it, I just want to be sure that you're QA is not set up with IMPLICIT_TRANSACTIONS.  Your who shows the QA is the runnable task, which...

Is it possible to post the code?

It would help to give a little better idea of the exact scenario.

Is this somehow wrapped in some big transaction?  Is the global table accessed by other procedures?

You said, firing from a trigger...is this trigger firing multiple times creating a blocking situation? ...