If you define an explicit transaction, and do the appropriate error handling, you can roll the whole lot back. I suggest using Try..Catch as @@error requires a check after every...

To recover in this scenario you need a full backup from before the table was dropped and an unbroken log backup chain from that full backup up until just before...

sqldba (9/23/2008)

---

One other thought,

Instead of creating two new file groups, Can I add two files to the same primary filegroup point to new disks, then use dbcc shrinkfile(filename, empty)...

Do you have a reason for wanting the queries to not run paralleled?

Dunno. Probably.

I've seen people suggest snapshots for month-end reporting with the intention of keeping the snapshots in place for a year.

Jack Corbett (9/23/2008)

---

I was wondering the same about the clustered index or the heap (some people still don't always have a clustered index). That's why I mentioned that it...

Doesn't mean that the index is completely appropriate. The DTA sometimes gets it wrong.

Can you please post table structure, index defs, query and exec plan please. (exec plan saved as...

Also have a read through this for a quick overview of how recovery models affect the tran log:

http://sqlinthewild.co.za/index.php/2008/07/23/recovery-model-and-transaction-logs/

You can, however if a column isn't indexed a change to it won't reflect in that DMV. I don't know if, for the purposes of that DMV, all the columns...

You need the full backup after the truncate to restart the broken log chain.

I don't think it will make any difference. The extra time comes from writing the original version of the modified pages into the snapshot files, not from searching through tables...

Can you post the exec plan please? (saved as a .sqlplan file, zipped and attached)

What was the error it was giving?

There's no DMV that tracks that. You can run profiler or you can put a trigger on to the tables to count the changes made.

As soon as you truncate the log you've broken the log chain. Any log backups taken after that point are useless and the log records will be automatically discarded (when...