在SQL Server 2008中插入/更新大量数据的最佳实践

I'm building a system for updating large amounts of data through various CSV feeds. Normally I would just loop though each row in the feed, do a select query to check if the item already exists and insert/update an item depending if it exists or not. I'm building a system for updating large amount