We know that when we issue Truncate then info not stored in transaction log file but when we issue delete from YYY table where ID >20 then removed info stored in transaction log file.
in my case i often deleting large volume of data from a table but not entire data from table. so i think if the same operation is going on after every few hour then there is high chance that my transaction log file size will increase lot. so please advise me how to remove data from table with delete statement but info will not be saved in transaction log file. any way exist? thanks