Plug the external drive into the machine that has SQL on, restore to the external drive.

Hang on..

dat, messages, images??? Is this a SQL Server database you're restoring (because SQL databases...

When you restore a backup, it recreates the database exactly as it was at the time it was backed up. It's not the size of the backup that's going to...

Yeah, looks very much like the client tool aborted the query because it took too long (timeout). Nothing wrong with the query, it's just taking too long. See if you...

The percentages in a plan are not times, they're estimated cost (emphasis *estimated*)

Can you post the plan and the table and index definitions?

Jonathan AC Roberts (11/26/2015)

---

If it is parameter sniffing causing the problem then you can just alter the stored procedure to copy the parameters passed in into ones created within the...

Please post new questions in a new thread.

No, I said if there is no existing index on the Detail table on MasterID, create one on (MasterID, ID). If there is an existing one on MasterID, add the...

Considering that, unless the backup was taken WITH CHECKSUM, verify only checks the backup header, there's not that much point in doing so. Better to restore it elsewhere and checkDB...

Looking at those in isolation, you probably want an index on (MasterID, ID) on the detail table. Check the existing indexes, make sure there isn't an existing one on MasterID...

Ask the DBA for the code and the plans please. Without them there's minimal chance that we can help you.

Have you tried with recompile and is the overhead unacceptable? I've...

Maybe. And maybe it'll make things worse.

Does the Recompile hint add an unacceptable CPU overhead to...

Yes, severely corrupted. Repair's not going to fix it. Only option here is restore from a clean backup or script, export and recreate the DB.

Decent, consistent layout, meaningful aliases, useful variable names.

And if it's...

Can you post the procedure along with the two execution plans (as .sqlplan files)?