>>One more link on this topic
>>
>>http://www.joehavelick.com/post/2008/02/27/Deleting-Records-and-Recovering-Space-in-SQL-Database.aspx
>
>This one explains why my log was getting monstrous everytime I was running my import script. As when it runs, it was deleting all records from the table first. So, using TRUNCATE will avoid that to fall in the log.
>
>Thanks


That's correct... Truncate table is not loggable, as well as select ... into.