Do you have a large ETL process to finish on day-to-day basis? Is your ETL process is suffering with performance loss during the BULK insert or export task? Are you using SQL Server 2005? If it is YES for all the above then you can take advantage of SQL 2005 in speeding up the ETL process to perform better. Also it is one of the best method I suggest to fine tune the performance. Say if you have a huge table and every night the same table is populated with another BULK INSERT task and on top of this...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/perftune/archive/2007/12/20/2992.aspx