Do you cache or not? By default SQL Server cache stores the data & query plan in cache to provide better performance for your queries. Similary caching is also included in SQL Server Reporting Services where this caching can shorten the time required to retrieve a report if the report is large or...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
01-07-2008
Filed under: sql server, performance, security, search, update, users, report builder, BOL, best practices, reporting services, books online, caching, cache reports
You can use the Report Manager by following these steps: Go to the folder in Report Manager where you have the report and click the Show Details button in the upper right. Click the Edit icon next to the report you want to share, and then click the Security link on the left. In the Group or username...