The database is in Simple recovery mode.
When I use the following,
truncate table testtable
insert into testtable with(tablock)
select * from testtable1
My ldf file grows big. This means that this is not following the minimal logging. But if I wrap truncate and insert into with begin and end separately the minimal logging happens,
begin
truncate table testtable
end
begin
insert into testtable with(tablock)
select * from testtable1
end
What is the reason behind this ?