I developed a report with BIDS which uses a stored procedure on MS SQL 2008 Database to populate its dataset used as Datasource. The report runs very slow (10 mins) and if the stored procedure is executed separately on MS Server Management Studio
(SMS) it takes only a few seconds with the same parameters. Appreciate if anyone could help on this issue.
View Complete Post