PASS Community Summit 2008: Program Sessions (Application Development)

SqlBulkCopy provides the fastest way to insert data in bulk, but when the data must be processed on the server prior to insertion application have had to resort to traditional APIs using row-by-row logic on the client side which have much lower performance. Table-valued parameters have row-streaming capabilities similar to SqlBulkCopy but with the added capability of processing the data on the server before rows are persisted in the database. Two common scenarios that will benefit from this feature are data transformation and merging. We will walk through a solution based on SQL Server 2005, and then look at a solution based on TVPs and compare.

Register Now for PASS Community Summit 2008!