What time did the full backup start and finish?

What time did the log backup run?

What time are you trying to stop at?

Steve Jones - Editor (4/7/2008)

---

Most people don't participate 🙁

Of the 10k-20k people, and 45-50k pages, we get about 300-500 responses quite often to polls and surveys. Probably should add them...

If you're running SQL 2005 (as I assume you are, based on the forum this is posted in), could you please save the exec plan as a .sqlplan file, zip...

Different owners?

Someone messing with Allow Updates?

Is there overlap between the unioned queries, ie, will a row be returned by more than one of them?

If not, change the unions to union All.

Union forces a distinct...

Apologies, this is more than a bit later...

How does this look?

There is some stuff left out, I don't know how you're doing the export of mailing, but the comments should...

I'm pretty sure that info's in the database boot page, but I don't know where or how to interpret it.

The one person around here who will know is Paul Randal....

Could you please post some sample data and expected output. Also the index definitions would be useful

Looking at your query, the multiple subqueries are very likely the cause of the...

Congrats guys.

Keep up the good work

I've read some articles that say that truncate is not logged, hence cannot be rolled back. The truth is that truncate is a partially-logged operation.

The row 'deletions' are not...

First thing is to check through the query and make sure that it is written as optimally as possible (avoid triangular joins, subselects in the select clause, functions on columns...

Sequel. Just because it rolls off the tongue easier.

The SQL Engine, by default won't release memory. You can specify the min and max memory settings (if necessary) and SQL will manage its memory within those boundries. The only...

Any IBM DB2 linked servers by any chance?

As a possible other option, you can run linked servers out of process. Then they get their own memory spaces and won't hog...

It's good practice to always specify the column names in an insert statement. I have modified my earlier post to reflect that