SqlShare.com Logo
 
Skip Navigation Links
Home
Video List
Events
Classes
About Us
Login / Register
Subscribe RSS Feed 

Takes Query Plan Analysis and Performance Monitoring to a New Level

The MERGE statement in SQL Server 2008

The MERGE statement is a new feature in SQL Server 2008 that implements upsert capabilities (insert if the row is not present, update if the row is present). This video goes over the full capabilities of the MERGE statement in SQL Server 2008.

Duration:
3 mins 24 secs
Skill Level:
100
Rating:
4.44 out of 5
Publish Date:
November 03, 2008
The MERGE statement in SQL Server 2008 You must be logged in to view this video.  
Bookmark and Share
 
1=Poor, 3=Good, 5=Excellent

About the Author

Image of Plamen Ratchev
Plamen Ratchev has over two decades experience in the software architecture and development field. He has enjoyed building solutions for UNIX, DOS and Windows platforms, with main focus on SQL Server since version 4.21. Plamen is founder of Tangra, specializing in relational database applications analysis, implementation, and tuning. His particular interest is in design patterns, performance a...

References



Comments
Sinshith.S on 6/23/2009
Superb

Travis on 7/24/2009
One of my favorite speakers at JumpStartTV! Concise, easy to follow, and most importantly speaks clearly and slowly! Great job Plamen.

Travis on 7/24/2009
One follow up comment though.. It would be nice if you provided the code too...

Andy Warren on 7/26/2009
Code for this video been added as a refernce - upper right corner!

James Moore on 7/27/2009
Cool feature. Thank you for taking the time to provide this video. It has been very helpful.

Ted Quan on 7/28/2009
Excellent!

24004BAFC6 on 1/28/2010
Very good. Nice and clear, covers all the issues.

jude on 2/1/2010
Excellent

Raju on 2/2/2010
I like the example with SQL statement explained. excellent

Roman Yusfin on 3/10/2010
Excellent video! Suggestion: add the OUTPUT clause for the MERGE. Regards, Roman

Plamen Ratchev on 3/11/2010
Roman, the OUTPUT clause was not demonstrated here to concentrate on the basic functionality of the MERGE statement. The following video demonstrates the use of the OUTPUT clause with MERGE: http://www.sqlshare.com/composable-dml-in-sql-server-2008_515.aspx

Denise Tsubota on 6/24/2010
I listened to several videos by this person and I find his accent is too strong, making him hard to understand and distracting from the information he is trying to convey.

erick on 8/18/2010
good stuff!

Ferruccio Guicciardi on 11/10/2010
very handy! im using MERGE tool for my current project and I am more than grateful! you save a lots of lines of T-SQL code!, Regards, Ferruccio Guicciardi

kalapala baburao on 11/10/2010
ok

Danny Costello on 11/10/2010
Very useful, thank you.

Lou Gallo on 11/10/2010
Great presentation! Simple and direct.

Jamshid Nouri on 11/10/2010
excellent merge sample demo

Sughanya on 11/10/2010
Nice Job

Juri Kirillov on 11/10/2010
Great to know... unfortunately i have to do the similar operation on databases located in different db-servers... so SSIS is only option

manjeet on 11/10/2010
Good Video for implemting in projects

manjeet on 11/10/2010
Good Video for implemting in projects

B on 11/10/2010
Again, he is very difficult to understand.

Krishna Agnihotram on 11/10/2010
good to know quick

7E97948D47 on 11/10/2010
It's great to see a quick video, you never know when you come across a command that you don't know.

Michael Miller on 11/10/2010
Very interesting! I had never heard about this function in SQL.

William on 11/10/2010
This was the first CLEAR explanation of the merge statement I've seen using all three canonical DML statements. Outstanding! Thanks!

Tom Hamilton on 11/10/2010
Nice clear example - thanks

Rick on 11/10/2010
GREAT!

Marie F Wilkinson on 11/10/2010
I love these videos, nothing teaches better an examples. Excellent example, much information packed into this video.

A43036427E on 11/10/2010
good presentation

1D73317FEF on 11/10/2010
Very good! Thanks

Lamar Marsengill on 11/10/2010
Excellent

WChaster on 11/10/2010
Well that is a nice feaature.

Amy Neumann on 11/10/2010
NEED more videos like this... ETL through SQL! Thanks

Mark Hathaway on 11/10/2010
Frankly, the presenter is hard to listen to because of his accent.

Awesome!

Kenneth Wymore on 11/10/2010
Wow, very cool. I can't wait for us to finally upgrade to 2008 so I can use this.

Brian Savoie on 11/10/2010
First explanation of "merge" that I've really understood. Thanks!

RAHUL DEV JAIN on 11/11/2010
OK

dave jordan on 11/11/2010
usefull

4B47653576 on 11/11/2010
well explained, good example.

Jeffrey Roughgarden on 11/11/2010
Nice addition to SQL, very well explained.

Ed on 11/15/2010
Nice. I can use it now...

nilesh bilimoria on 11/17/2010
Nice job in explaining a complex situation with simple words.

Talha on 11/24/2010
more videos on this please

Jeremy Hill on 11/30/2010
Very interesting and clearly demonstrated.

Stephen on 12/3/2010
Good content, however, it might be helpful to explain the conditions that apply in the "when matched" clause.

Vagner on 12/20/2010
That's a excelent feature which I've never knew about.Plus the owner of this demo explained it very well!!

Joe Ty on 1/14/2011
presentation was easy to follow

John O'Sullivan on 2/10/2011
an excellent example

Maurice Ivory on 5/13/2011
It was okay...the video had alot of information in there.

Sur Man on 5/27/2011
Plamen, The end result of this exercise is truncating the CentralAccounts table and inserting all records from the BranchAccounts table in to CentralAccounts table, which is easier to implement than the merge statement, isn't it?

Plamen Ratchev on 5/28/2011
Sur Man, if there is large amount of data then deleting and re-inserting all rows will be inefficient. Using Merge you can update only changed rows and insert new.

Olu on 7/14/2011
I quite liked it - the example was easy to follow

pash on 8/24/2011
very helpful

Frank on 1/2/2012
Excellent

Richard Scott on 3/5/2012
Most helpful.



Must Be Logged In
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions