Home Forums Article Discussions Article Discussions by Author Discuss content posted by Roy Ernest Importance of UPSERT RE: Importance of UPSERT
sqlvogel
SSCrazy Eights
Points: 9526
More actions
January 29, 2008 at 4:57 am
#772788
SQL Server 2008 users should definitely consider using MERGE. MERGE will avoid having to do multiple scans/seeks in many cases.
http://blogs.conchango.com/davidportas/archive/2007/11/14/SQL-Server-2008-MERGE.aspx