All,
We have a current setup where we are pulling data from a transactional db and there are some reports running against it . Each report having a stored procedure running against the transactional db.
What are the possible ways in which we can optimize the current technical design.
Thanks in advance.
phn051000 
(BOB member since 2009-05-10)