File MDF growth SQL Server 2008
If the database is set to "simple" mode, then the transaction log is truncated after the transaction.  Because you are only inserting 1000 records at a time, the transaction never needs to grow the entire amount.