What version of SQL did that database come from? What version are you trying to attach it to?

What do you mean by slow? Queries taking longer than the should? Queries timing out? All operations (including remote desktop) slower than normal? CPU maxed out?

It's strongly recommended that neither logs nor data files are...

Not just any query, the queries that your...

If you can get the SPID for the process that is running the query that is running slow and then look at the status of that query in the results...

Last point. Don't put a shrink database/file task in the maintenance plan.

How did you manage to corrupt the files? Short of taking a hex editor to them, it shouldn't be possible for you to corrupt a file.

Prints are buffered and are not returned the the client immediatly. While I've never seen multiple prints out of order, I have seen them greatly delayed. Try replacing the print...

Very strange.

Is the invoice verification using linked servers by any chance?

Right now I'm thinking it's poossibly got something to do with compile time. Perhaps try getting the admins to run a trace on Cache hit, cache miss, cache insert, RPC...

Ah. Fun.

How is the query constructed on the front end? Parmaterised (I somehow doubt) or concatenated strings?

I assume this is in a stored proc. Can you post the rest of the proc please?

One thing that may help.

convert(varchar,tab.TreatmenRegimenNumber)+ ','+convert(varchar,tab.RevisionNumber)

not in

(

select convert(varchar,TreatmenRegimenNumber)+ ','+ convert(varchar,RevisionNumber)

from TreatmentRegimen TR

...

Vika (8/29/2008)

---

Guys,

The database suppose to be setup on the disk where everything gets backed up automatically but following the written instructions (that had an error in the path!) he set...

It's usually a good idea to create indexes on foreign key columns, however you should check and make sure that SQL is actually using them. You can do that by...