What should I do? how can I clean it?

There is a script that someone ran, delete records from table and then insert records

Thank you, but this code I run takes to long and Begin Tran takes much faster,do you know why?

DECLARE @RowsUpdated int;

SET ROWCOUNT 4000000;

WHILE 1 = 1

BEGIN

UPDATE t1

SET Qty = t2.Qty

FROM dbo.Table1 t1

...

SET ROWCOUNT 4000000;

WHILE 1 = 1

BEGIN

UPDATE t1

SET Qty = t2.Qty

FROM dbo.Table1 t1

INNER JOIN dbo.Table2 t2 ON t1.KU = t2.KU

WHERE t1.Qty IS NULL;

IF @@ROWCOUNT < 4000000 BREAK;

END;

Why are you not...

If do it like this,my logs will not get full right?

Thank you, I don't want to pause anytime,just wanted to know for future if I need too. So, I have 48 mil to update in production, If I write this...

SET ROWCOUNT 4000000;

WHILE 1 = 1

BEGIN

UPDATE t1

SET Qty...

I am trying to update 48 million records and I don't want to update them at the same time. What I am doing worong?

BEGIN

SET ROWCOUNT 4000000;

BEGIN...

Thank you,but I wanted to commit 100 and then again 100. How can I write it.Thank you

You mean

Begin

Begin transaction

Update statment

Commit

End

How can I right code that I want every 100 records to commit?

I ran the command to 10% limitation, do I need to re start sql server? I already see that file now is 32,000,000 MB.

I need to update 48 mil records,...

I am only using 2 joint tables,one of that table contains 48 mil. I am not using temp tables. But how can I clean my drive space now?

How can I re write my update statment? I need to update 48 million ,but now I need to clean my drive space asap. Like I said temp db got...

What information you need. I just because of this update I was running,on the drive whe re my db leave we have 10MB left. My temp my mdf file is...