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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by
on
Mon, Jan 7 2008
Filed under:
Filed under: sql server, performance, security, search, update, users, report builder, BOL, best practices, reporting services, books online, caching, cache reports