Well, the clustered index is the data, so I think you're looking at the larger number. Index_size only includes, I believe, the non-clustered indexes (as well as XML, spatial...

Don't know. Where did that data come from?

John

In that case, I'm not sure why your transaction log should grow to nearly three times the total size of your indexes. Does that 60GB include the clustered indexes?...

Jason

You're only running one ALTER INDEX statement at a time, so it doesn't make any difference whether you use an explicit transaction or not. I think what Lynn was...

If it's a simple while loop, they'll execute serially anyway and therefore putting a delay between them won't have much effect. Are you sure you're using option 3 that...

Maybe you've got an uncommitted transaction or something like that. How much free space is there in the log file after the index maintenance has finished and the log...

Once the rebuild of any index has used up space in your transaction log, that space won't be freed up again until the transaction log is backed up. You...

Is your database in Full recovery mode, and if so, how often do you back up the transaction log?

John

You're doubling up your quotes. If you avoid doing that, it should solve your problem. If you're working in Management Studio, everything enclosed in quotes should be coloured...

Who told you to do that? Please will you post the CREATE TABLE statement for Table A?

John

You shouldn't do that, because you'll destroy your referential integrity, and chances are you can't do it anyway, since the REASONSREFERRAL column probably has a data type that won't allow...

Presumably you're hitting an error in your TRY block and breaking out of it before the COMMIT TRANSACTION statement is reached. Can you not lose the explicit transaction -...

I'm not sure it would, to be honest. They'd be two different sessions. You'd need to test. But even if it did work, I'd strongly recommend against...

Use a UNC path, not a mapped drive. The mapped drive is only visible to the user that mapped it, not to the SQL Server service account, under whose...

Use DISTINCT when you want to eliminate duplicates from your result test. If you use it in an existence test, like you did in your original post, then it...