"Harpreet" wrote:

> Di dyou get a solution to the slow running report?
> I am using report models and reports are painfully slow.
>
>
> "Mike.Seddon" wrote:
>
> > Just wondering if anyone would know why a report would work fine for around
> > a week, running within 6-7 seconds, then suddenly take 25 minutes to run?
> > Doing an update stats appears to cure the problem. The source database is
> > loaded several times each day. Running the SQL statement directly in SQL
> > Management studio, even before the update stats is done, retrieves the data
> > in seconds, so it wouldn't appear to be a SQL problem. I have seen articles
> > hinting at reporting services having its own statistics collection? but only
> > where cubes are involved, there is no cube in the data this report needs. We
> > are running SQL server 2005 service pack 2.
> >
> > thanks for any help in advance
> >
> > Mikey :o)
> >
> >