help please 2 questions | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

help please 2 questions

First I am using merge replication and sometimes it is nessesary to make a big delete or update for example 500 000 rows and it takes whole night to complete is it possible to send this to subscribers just like stored procedure if not which is the best way to do so,
Second I have a table "transactions" with 20,000,000 rows is it better to seperate into this tables"deposits", "withdrawals", "transfers", "loans", "payments" or to keep just in one table thanks in advance

What are the typical operations that you carry out on this table? And what is their frequency? Gaurav
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

Also: – do you use row or column level tracking
– what is your retention period
I can’t think of a way to get around the 500,000 row delete problem other than
– stop all activitity on the databases
– delete subscribers
– delete the rows on the publisher and subscribers
– create the subscribers specifying the the schema and data is already on the subscribers (i.e. don’t apply the snapshot) I don’t like the sound of this though… Cheers
Are the deletes going through RI constraints? Do you implement RI on the subscriber also? These can seriously affect replication speed.