Browse by Tags

SQL Server Reporting Services - Do you cache popular reports for better performance?

Published 7 January 8 5:30 AM | SSQA.net

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...

Filed under: sql server, performance, security, search, update, users, report builder, BOL, best practices, reporting services, books online, caching, cache reports

November 2007 update SQL Server 2008 Books Online CTP - update your local copies

Published 2 December 7 6:46 AM | SSQA.net

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...

Filed under: sql server, microsoft, download, update, users, 2008, books online, ctp5, utilities

Msg 18456, Level 14, State 1, Server <ServerName>, Line 1 Login failed for user '<Name>'

Published 18 May 7 5:56 AM | SSQA.net

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...

Filed under: sql server, update, users, instance, localhost, error, login