Interview Question in Sql Server 2005


 

Interview Question :: Same question with Tristan B. slow reporting services

I have a report which is rather complex with many tables, joins and subqueries using the with clause. It runs for 30 seconds in the Microsoft SQL Server Management Studio. However, when previewing in the preview tab in Visual Studio 2005 it takes 10x as long. The SQL is copied into the .rdl file verbatim. Likewise, when I published the .rdl file to the report server it is equally as slow. What could be the problem here and how could I fix it?

Regards,

Kai
by ksk