i am using SQL SERVER t-SQL.
I have a table using SSIS, i load the table in the warehouse from a live Database every 15mins.
Because there is so much information i would like to maybe split the table and create dumps for maybe every month but i do not really know where to begin.
Because when reporting using this table i could be pulling data for many months i didn't want to be including loads of tables in the query and causing run time errors.
I was trying to think of creating a table which would hold an id for each 'monthly table' and by calling the
id in this table it would pull the data from the other tables.
Has any one any ideas on how to do this, or of another idea that could be much better, please advice?
If I am not explaining myself please let me know and I will try again,