Steve - thank you for your feedback, we'll look to calculate based on your recommendations. - Cheers !

Jeff and Sue,
thank you for the recommendations. We'll start looking into index defragmentation and update statistics tasks.

regards
SQLjay

bumping once, hoping for some feedback:-)

thank you for the feedback. It is appreciated.

Glad to know no concerns to replication was seen in a mixed SP configuration. Given the number of associated subscribers, it would take...

this can be accomplished by setting up filters on specific columns.

Our primary ERP database has business data for all locations.

We have many sites.

Each site is a different branch plant.

When...

Grant, Clive,

Thank you for taking the time to provide your feedback.

I thought to go back to the basics in tackling this issue. I identified all the tables associated with this...

I'm interested in knowing this as well. We also log ship and have replication configured.

Similarly as you, I am wondering if there can be a mixed match SP configuration...

Just a follow up question perhaps looking for some further clarification as I might be reading an old thread on the web.

Was there ever a need to run both...

Thank you very much for the replies, guys. It was very helpful.

Cheers,

SQLJay