• dwilliscp (9/7/2012)


    Michael Valentine Jones (9/7/2012)


    You haven't provided enough information for anyone to begin to answer that question.

    You should just try each way to see which is faster.

    The problem with that is.. before the second run I would need to make sure the data is flushed from memory... not sure how to do that. Otherwise the second run should always be faster since it does not have hard drive I/O.

    CHECKPOINT;

    DBCC DROPCLEANBUFFERS;