Just like to share with every one my performance tips for front arena installation at one of our clients. I fixed the issue by

We minimized transaction logs. Any operation that move a large amount of data between tables is a candidate for select..into operations. We identified these cases. The transaction logs are just not big enough to perform a regular insert..select

Also, transaction logging takes time. If performance is an issue and incremental backups are not needed, then select..into does makes sense.