You can achieve very high performance with the BULK INSERT interfaces in SQL Server 2005, from SSIS, ADO, TSQL or plain old bcp. Many times you would like to be able to perform bulk updates with the same performance, however there is no command to support this. If you would like such a feature in a future...