• pmscorca (11/19/2013)


    Ultimately, the batch approach seems the better solution ..., isn't it?

    Test, test, and test!!

    There are a number of techniques to populate a test table with millions of rows in a very short time. Then you can implement the different different scenarios to see which is the fastest, uses the fewest resources, has the best execution plan, etc. . .

    __________________________________________________________________________________________________________
    How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/