Optimizing Microsoft SQL Server 2008 Applications Using Table Valued Parameters, XML, and MERGE

Embed code for this video

Copy the code above to embed our video on your website/blog.

Close

Video format

Note: These selections will fall back to the next best format depending upon browser capability.

Close

Download

How do I download the videos?

  • To download, right click the file type you would like and pick “Save target as…” or “Save link as…”

Why should I download videos from Channel9?

  • It's an easy way to save the videos you like locally.
  • You can save the videos in order to watch them offline.
  • If all you want is to hear the audio, you can download the MP3!

Which version should I choose?

  • If you want to view the video on your PC, Xbox or Media Center, download the High Quality WMV file (this is the highest quality version we have available).
  • If you'd like a lower bitrate version, to reduce the download time or cost, then choose the Medium Quality WMV file.
  • If you have a Zune, WP7, iPhone, iPad, or iPod device, choose the low or medium MP4 file.
  • If you just want to hear the audio of the video, choose the MP3 file.

Right click “Save as…”

Slides (view online)
This session covers passing sets of data from a client application to a SQL Server 2008 instance. There are several solutions to this task, including the use of the SQL Server 2008 feature Table Valued Parameters (TVPs). In this session we describe and compare multiple approaches to passing sets of data to SQL Server, such as calling a stored procedure repeatedly, passing the set as XML and passing the set using a TVP. We also cover combining each solution with the new MERGE statement. A discussion on pros and cons of each approach as well as a look at end-to-end demos on each implementation is a promise!

Comments Closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.

Event Homepage

Tech·Ed Europe 2009

More sessions in this event

See More

Related sessions

Creative Commons License

© 2012 Microsoft. Except where designated as licensed by
Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 License,
Microsoft reserves all rights associated with the materials on this site.