Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Merge not always a life saver Expand / Collapse
Author
Message
Posted Monday, June 20, 2011 8:33 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, November 12, 2012 4:54 PM
Points: 54, Visits: 816
I concur what dawalker-1068762 has said. MERGE is a wonderful command but use carefully. If the source (SRC ) table is small and light it is feasable and nice to use. But if the table has millions of rows then you will hit a performance snag.

To get around this we are using MERGE along with a batch process. User very carefully! and design things in batches.

Wish MERGE had a parameter to do batch processing!
Post #1128289
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse