This is going to sound unconventional, but I would try to find some common ground with your colleague. I'm guessing they're new to the team and have something to prove,...

What message is in the history for the maintenance plan (right click, history)?

I get the same error only in the context of a stack dump or login failure. Eg:

Using 'dbghelp.dll' version '4.0.5'

The client was unable to reuse a session with SPID...

Ok, so we're only looking at 5MB of data for the subquery. What about the estimated query plan for the modified query? Is it still going wrong?

There's some very dodgy joins in there. When you join on a substring or function, it's going to slow everything down. Can you modify the joins to SAP_MARA?...

Can you also script statistics with histogram?

Hey seiyak2009, what happens when the business just decides to record the oil price every 5 seconds due to a new fast trading platform introduced at the company? Your...

You should be able to do an estimated execution plan rather than an actual execution plan.

Was that execution plan with FORCEPLAN ON? If so, can you post the other plan and also script the table definition and any index definitions

probably permissions.. whats the error when you try restore? OS error 5?

Who is the head blocker and what are they doing?

Run this:

SELECT dm_ws.wait_duration_ms,

dm_ws.wait_type,

dm_es.status,

dm_t.TEXT,

dm_qp.query_plan,

dm_ws.session_ID,

dm_es.cpu_time,

dm_es.memory_usage,

dm_es.logical_reads,

dm_es.total_elapsed_time,

dm_es.program_name,

DB_NAME(dm_r.database_id) DatabaseName,

-- Optional columns

dm_ws.blocking_session_id,

dm_r.wait_resource,

dm_es.login_name,

dm_r.command,

dm_r.last_wait_type

FROM sys.dm_os_waiting_tasks dm_ws

INNER JOIN sys.dm_exec_requests dm_r ON dm_ws.session_id = dm_r.session_id

INNER JOIN sys.dm_exec_sessions dm_es ON...

Post the query and execution plan as Gail requested.

You don't want to use the FORCEPLAN ON option as you're addressing a symptom and not the cause. It's...

A barcode is a number font. Try this:

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/1aada9df-9c2c-44b6-bd00-b3c60b8d1931/

sp_who2

I use an automated baseline / performance monitoring tool rather than manually baseline.