Query pulling 12-15 GB data From more than 120 tables
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.
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.
Any suggestion any ideas please to make this hell of task a bit simpler,
quicker and less error prone ???
No comments:
Post a Comment