This is actual data of one of my table with a clustered index. It comes when I do : sp_spaceused TableName

John Mitchell-245523 (4/29/2013)

---

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

One question to all:

If I have data like this, where there is only one clustered index on table and index size is 2976 KB.

name ...

There are no indexed view. Yes, clustered indexes are included in that 60GB.

John Mitchell-245523 (4/29/2013)

---

In that case, I'm not sure why your transaction log should grow to nearly three times...

The size grows every time during maintenance. I use DBCC SQLPERF(Logspace) and sp_helpdb to monitor it.

Here is the edited while loop part:

WHILE EXISTS (SELECT * FROM #tmpIndexes WHERE Completed =...

Hi

Each one is a separate transaction as I don't use any BEGIN TRAN etc. it's a simple while loop with rebuild statement between BEGIN and END.

Lynn Pettis (4/29/2013)

---

Okay, I will...

Hi Gail

My biggest index is 16 GB and size of all indexes combined is 60 GB. May be combined with other load, it reaches to 160GB. I was curious if...

I don't think there are any long running transaction that time when maintenance is happening.Once the maintenance is over after 2 hrs, and if I run DBCC SQLPERF(Logspace), the used...

Hi

I don't have the option 1.

Option 3 , I am already doing.

So I am left with option 2 only. Here also, the log size takes 2 hours to grow to...

yes, it's in full recovery and log is backed every 20 minutes. I checked this and log backups are happening fine every 20 min

And what about detach?

Thanks Jeff. I also figured from different articles that it can be solved by service bounce. But problem is the bounce is scheduled for weekend and I have to move...

But the transaction that xp_cmdshell did was quite small: just creating a test file. it should have taken less than a second to roll it back.

Will killing the explorer.exe from...

Thanks Gail. I value your opinions very much. The job actually will be run every week. I had this in my mind to automate this.

Any specific reasons you prefer this?

Actually the real database is pretty big, around 8 TB. And some of the tables are as big as 900 GB. So to make take advantage of partition elimination (...

Well, I can't give the reasoning as it has been there for years. So I have to start from what I have been given.