title: Which is faster for multiple SQL calls - parameterized queries or stored procedures?
body: <p>I'm using SQL Server 2005. I'm looking at opening a SQL connection, looping though a collection and running an update query (stored procedure or parameterized query) with the data from the collection item, then closing the connection.</p>
  
  <p>Which is going to give me better performance and why? </p>