title: Table-Valued Parameter versus multiple Insert rows performance question for inserting into SQL Server 2008
body: <p>If all I'm doing is inserting multiple rows of data into a single table in SQL Server 2008, which is faster? </p>
  
  <p>A <a href="http://msdn.microsoft.com/en-us/library/bb675163.aspx" rel="nofollow">Table-Valued Parameter</a> or <a href="http://blog.sqlauthority.com/2008/07/02/sql-server-2008-insert-multiple-records-using-one-insert-statement-use-of-row-constructor/" rel="nofollow">a single insert statement with multiple values</a>? </p>
  
  <p>Where in this simple scenario would you prefer one over the other? </p>