I found the following article that state that you should a good backup before you Kill the process.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=153850

I deleted it and it worked.

Last time I deleted it in T-SQL Code.

Thank you.

It takes forever but it eventually generates the Code.

I was thinking Oracle Free Space. :blush:

Thanks for the insight.:-)

It's moving fast unlike this weekend...

It is moving very slowly on a 30 million record table.

Thanks. 🙂

One of the just worked. Started another and I'm getting a LOGBUFFER WAIT TYPE.

Wait Types are mostly CXPACKET. Also getting SOS_SCHEDULER_YIELD.

There is definitely no blocking going on.

Thanks!

I'm rebuilding first because there was...

I shrinking the file from SSMS. I specified reorganize before releasing space.

That could take some time on a .9 Terabyte File.

Initially I just wanted to reduce fragmentation.

Now I'm trying to reduce the size of the Data Files.

The ndf reduced pretty well but the mdf went from over 422 GB to...

I rebuilt the Indexes on most of the tables in one of the Database and I only have 20% free.

I thought that I would have more than that.

I'm rebuilding the Indexes.

I have rebuilt a lot of tables but I only have 9% free. It does not appear to be changing.

What am I doing wrong?

This Job has been running successfully for years on this Server when I upgraded it to SQL Server 20008 R2.

Nothing has changed.

Thanks.:-)

Eirikur Eiriksson (6/8/2014)

---

For fun, a quick demonstration

😎

/* 250 Gb */

DECLARE @MY_NumberOfBytes NUMERIC(12,0) = 268435456000;

/* bytes */

SELECT

'Bytes' ...