What all is running on the server? Any processes outside of SQL Server? Are you using CLR and/or SSIS or any of the other tools / apps? ...

There is no "article in question" as it's the entire process. Once I did have that single error and that appeared to be a precipitating factor for the long...

Update:

I rebooted both servers and the first time the job ran it ran within the expected time frame.

Next time, back to taking way too long.

I adjusted the schedules thinking maybe...

Nope. The process has a near-exclusive lock on the table.

Tell me about it.

We have a couple of different monitoring tools in place (VM Ware's admin/monitoring tool and RedGate's SQL Monitor tool) and I'm not seeing anything too out of...

Yeah, I know it makes no sense. No triggers, no dependencies. I did try to take a look at the file but couldn't quite figure out how. ...

It's a complete drop and refresh.

Because of how the application is handling this query - not to mention the fact that the query itself is very poorly written* - it's bound to wind up with...

bad plan got cached.

If you need an argument, Non-ANSI join syntax is deprecated, so it will need to be removed/changed in the near future. Also, their non-optimized code creates great risk of...

How are you doing the insert? With that many rows I'd suggest BCP.

For progress, a simple way would be to do a

select count(1) from table with (NOLOCK)

where...

Any chance of getting this query into a stored procedure rather than being called from the application directly? With the way the query is written I'm sure the optimizer...

You should also consider running it through an SSIS package.

Doesn't look like there's a direct way to do it. See:

http://www.sqlservercentral.com/Forums/Topic885747-1291-1.aspx

for some possibilities.

[ @query = ] 'query'

Is a query to execute. The results of the query can be attached as a file, or included in the body of the e-mail message. The...