Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic885294-1044-1.aspx

Do you get them while building the search indexes?

No. Backup with the CHECKSUM option.

And both are for full and log backups, not just log

No, you don't want to run a checkDB every time you back the log up. That's just insane. If you're backing up every 15 min, CheckDB can easily take longer...

Put it this way. Would you rather...

Excluding the calculator, that's standard exam centre...

Do you think that you could grab that Statistics XML plan and post it please? As I mentioned, I mixed the two profiler events up, and the showplan doesn't have...

Edited..

Is that the only index on the table? No primary key?

Your data is committed to the data file. That happens shortly after a transaction completes. In full recovery, the inactive log records are not cleared until they are backed up.

The pass mark is 700. The number of questions varies and there's no way to tell how the questions are scored.

That just shows a table scan. It's not using any index at all, estimating one row only. Looks like it's only a partial plan too, not sure why, so lots...

1) Whenever a checkpoint occurs. Only log records up to the beginning of the oldest open transaction can be truncated.

2) Do it in batches and run CHECKPOINT between those batches.

Order of returned rows is NOT guaranteed unless ORDER BY...

David Nash-367764 (3/17/2010)

---

What I meant to say when I said it's not a poorly performing query is that the sql generated is very efficient. The query itself still takes too...

:hehe:

I have 3 t-shirts now that have geek written on the front. One of...