I'm saying that's a pretty extreme statement to make, claiming that all subqueries and derived tables cause TempDB overhead (which, btw, would not show as physical reads, they'd show as...

You have, of course, a reference or an example showing...

There's no easy way (and the link previously given just shows the queries to fetch the missing index information, which is not what was asked)

Grant has, on his blog somewhere,...

Please post new questions in a new thread, don't hijack an unrelated thread

Sean, do you have the actual execution plan for comparison? I've seen obscene row estimations before, I suspect caused by the optimiser thinking that a one-to-many join was a many-to-many...

About bloody time too.

Please post new questions in a new thread. Thank you.

That looks like IO subsystem, the page headers are invalid, not something an import could do. Doesn't have to be the drives, could be anything in the IO stack.

Good luck with that.... You're going to likely have a large number of false positives to clear out, not to mention you don't know whether or not the procedures are...

Be patient, take a good book.

Or copy the files to an external drive and courier/drive it...

No. You can get the queries that currently have cached plans by querying the sys.dm_exec_query_stats and sys.dm_exec_sql_text DMVs, but that's all.

Create a logging table.

Add a line into every procedure which inserts or updates that table (your choice) to indicate is has been called.

A year or so later (an entire...

http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/

Stored procs:

Add a table which records usage. Add a line to each of the procedures which inserts into that table when called (or updates an existing row) to show when...

Michael Valentine Jones (7/31/2014)

---

The last vendor I had to deal with had an application that required the use of a specific SA password to connect to the database on a...