Please let me know if this is possible and a reasonable procedure. Thank you in advance.
I have a SQL Server table that we use strictly for reporting that is updated daily through a dts package and our legacy system. This table has gotten very large and slow to report on now that it has almost 3 years of data in it.
Can I pull the data out based on year and put into a separate identical table and have those tables "connected" for reporting purposes? Can I do this with multiple tables and have a process that will create a new table for, say, 2004 data, 2005 and so on? Would this help with the efficiency of the reporting environment?
How to's or suggetions would be greatly appreciated.
Thanks again.
I have a SQL Server table that we use strictly for reporting that is updated daily through a dts package and our legacy system. This table has gotten very large and slow to report on now that it has almost 3 years of data in it.
Can I pull the data out based on year and put into a separate identical table and have those tables "connected" for reporting purposes? Can I do this with multiple tables and have a process that will create a new table for, say, 2004 data, 2005 and so on? Would this help with the efficiency of the reporting environment?
How to's or suggetions would be greatly appreciated.
Thanks again.