arbarnhart (10/17/2008)

---

Thanks. I may try the temp table. The reason I didn't try to provide all sorts of detail is that I was/am trying to ask a somewhat generic question....

Get profiler to script the trace. (File - Export). Put the script in a SQL job, make the couple of required changes (specifying a filename and the end time) and...

And please don't post in all caps. It's the online equivalent of shouting at someone. It's also hard to read.

Do you have speed problems with the queries from your application, or do you just have speed problems with browsing the metadata in management studio?

Well written, efficient queries and indexes that support those queries.

It's not a particularly comfortable time to be without a steady income (consulting), but things aren't as bad down here (South Africa) as in some other parts of the world....

Leo (10/16/2008)

---

1. How do we know database is corrupt before the Backup at 22:00? Job is already setup and backup the corrupt database anyway according from the JOB. Any way...

Sure....

Can you post the trigger?

Is the insert fast when done on the server, but slow when done across a linked server?

Yes, you can replace the two indexes. With the include columns, the order they appear doesn't matter.

Yes. In fact I've just finished tearing my hear out over exactly that scenario (though I had 315 tables to do).

You can't do it with SQL 2000 though. It...

Your strategy sounds good, though I might suggest running the tran logs more often. If the log drive fails, is the loss of 3 hours data acceptable?

I'd also suggest...

As far as I'm aware, execution contexts are cached per user and per procedure, not for each statement in the procedure.

Not really. The revised version (especially with more than 1 parameter) is likely to table scan all the time. That query has no single optimal plan

The usual recommendations (and often...

Don't use locking hints, at least not as the first thing you try

Frequent blocking and deadlocks are usually caused by bad code, bad indexes or both. See if you can...