none
How to optimize multiple SProcs inserting into same table

    Question

  • Hello All,

    I've about 45 different processes that insert data into the same table. Each Sproc takes about 45 seconds so the entire process takes a long time. What would be recommendations to optimize this? Should I create 1 spearate table for each of the Sprcos and then fire them up  using SSIS or would there be another better approach?

    Thanks!


    GBM

    • Moved by Kalman Toth Friday, September 20, 2013 1:15 AM Not t-sql
    Thursday, September 19, 2013 11:17 PM

Answers

All replies