July 4, 2006 at 11:59 am
Table A
Table B
Table C
Table D
Cude_1
The currecnt situation is that we have different servers sitting down holding various types of data, we have stored procedures that are scheduled as jobs that update Cube_1 eg do summary counts, sum(), sount(*) etc, If the jobs does not run, it means that Cube_1 will be out of date because there are a lot of records involved with a lot of IO/CPU resources, we are currently looking for a solution whereby there is a cube table which is automatically updated every time inserts/updates are made on the following tables:
Table A
Table B
Table C
Table D
I am not sure if there is a feature in SQL 2005 which can take care of this problem ?
Or maybe another smarter/sensible way of doing this ?
July 5, 2006 at 1:21 am
Possible solution is use of ROLAP partitions for example. Than U have "online" cube. U have to gather all the tables ino one database (ROLAP requires possibility of indexed views creation)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply