title: Query pulling 12-15 GB data From more than 120 tables
body: <p>I have a query which is pulling data from almost 125 different tables, I have created some 13 nested Stored Procedures calling other stored procedures to pull all the required data. Surprise Surprise Surprise The query takes ages to execute and sometimes I have to kill he connection and rerun it. </p>
  
  <p>I have been advised to make use of staging table, Move required data there using SSIS packages and pull data from there, but I am a bit reluctant to use SSIS as Im not very comfortable with SSIS and This report is requested once in a while and also moving around 10-15 gb data for one report seems a lot of hassle. </p>
  
  <p>Any suggestion any ideas please to make this hell of task a bit simpler, quicker and less error prone ???</p>