SQL Server 2008 - Table valued parameters
If you have to insert more than one row of data in a Table, you end up
executing the insert statement / stored procedure as many times for
each row, with Table-valued parameters you can send multiple rows of
data to a single TSQL statement or stored procedure without creating
temp tables or doing multiple round trips.
Table-valued parameters are a new parameter type in SQL Server 2008 and are declared by using user-defined table types.
Change Data Capture SQL Server 2008
CDC
or Change data capture is a new feature in SQL Server 2008, which is an
ability to record changes to table data into another table without
writing triggers or some other mechanism, Change
data capture records the changes like insert, update, and delete to a
table in SQL server thus making the details of the changes available in
relational format.