Advanced Scenario: Processing a large data set

[anna_holland]

We thought we would give the community members another chance to answer a use case scenario thread. After we receive a few responses, we will post the answer that was provided by our internal product experts so that you can see how the various responses compared. This week we are sharing best practices on Data Management Studio to speed up processing of large data sets. We want to know what your approach would be?

Scenario: “What are the best practices for splitting up work that involves performing address verification on a large number of records? Specifically, what is the best way to split up the job processing and shorten the overall execution time of the job? Alternatively are there some DMSERVER settings I can change? What are the techniques / recommended best practice for doing this?"

As a community member, what would be your solution?