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
As the subject states you have to update (uninstall & install) the local copy of Books Online for SQL Server 2008 CTP that is released in November 2007. This BOL update consists all the changes from the previous CTPs and what's new with current CTP release. BOL information has been useful since...
You might have come across this instance of error within your environment: Msg 18456, Level 14, State 1, Server <ServerName>, Line 1 Login failed for user '<Name>' The above error used to drive me nuts when the users complained by specifying the error number. But not now as I have...