Krishna1 (4/15/2013)
the script given gives me the size of the log file and used space. I would line to know why delete operation should increase the log file?
Deletes are fully logged. If something occurs which prevents the transaction from completing then the whole transaction would be rolled back using information from the tran log.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden