The question was to change it to 23:59:59. I did not ask why.

The size of one transaction is 620 MB at the end of the transaction. It is strange to me that after the transaction the transaction log shrinks with a full...

When you delete 540000 records and add 540000 records the logfile grows to 1054MB but when the transaction is finished only 22,9MB of the logfile is uses and 1032MB is...

I've tried again, but the logfile starts at 10MB in use, grows to 504MB and after the transaction is finished is returns to 257 Mb.

But the recovery model is...

With only a primairy key  it grows to 150MB, when you add a unique constraint on 7 fields it grows to 604 MB: the indexes do matter.

But during the transaction...

Thanks,

By trying

begin transaction

delete from xxxx

where xxxx_id>270000

insert into xxxx

select * from xxxx2

where xxxx_id > 270000 and xxxx_id < 540000

commit transaction

the logfile grows till 604 MB,

while the table xxxxxx with 540000...

-Does a user have to be a System Administrator in order for their objects to automatically be DBO owner ?

I think so. I have a programm that must be...