SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

It Depends

Add to Technorati Favorites Add to Google
 

Replicate Stored Procedure Execution Published on SSC

By Andy Warren in It Depends | 11-05-2007 1:51 PM | Categories: Filed under: , ,
Rating: (not yet rated) |  Discuss | 605 Reads | 101 Reads in Last 30 Days |no comments

Most people 'set it and forget it' when it comes to replication, not realizing that changes to rows on the publisher are applied one row at a time on the subscriber using the system generated procs created on the subscriber. I actually tend to agree with the concept, opting for a vanilla implementation whenever possible! Needing to update or delete a large number of rows is one place where vanilla plus a dab of butterscotch in the form of replicating stored procedure execution can make a big difference in overall time/resource usage.

Here's the link: http://www.sqlservercentral.com/articles/Replication/61332/

Comments
There are no comments on this post
Leave a Comment
Only members of SQLServerCentral may leave comments. Register now for your free account or Sign-In if you are already a member.