xx

I agree.  I didn't catch the Begin tran part.  Why wrap it in a tran at all since you can esily redo the whole thing if there are any issues. ...

Several things you need to do to ensure you get peak performance for this type operation.  One is to add a RAID 1 and place the log files on that....

Why is that dumb?  You have to consider where this all came from or where it may go. Especially TAPE devices.  You usually can't delete a part of the tape...

There is no way.  It is all or nothing based on the INIT or NOINIT option that you use.  If you want to retain x many days then you should...

Iagree, the wording is plain wrong...

You need to have a Clustered Index on this table for it to do any good at defraging the table.