Long running queries in complex reports is one key performance optimization area. One way to keep your users from waiting for a long period of time to view a report, due to corrupt queries or poorly designed queries, is to configure your reports with an acceptable time limit to wait for the database engine to [...]
Category Archives: SQL SERVER/ORACLE
Controlling/Handling/Optimizing dataset processing time in SSRS reports Asp.Net C# Sql
Posted by james on March 23, 2011
0 comments
Best/Easy Way to Resolving could not open a connection to SQL Server errors Asp.Net C#
Posted by james on March 23, 2011
0 comments
Sometimes you may have issues connecting to SQL Server and you may get messages such as the following:ERROR: (provider: Named Pipes Provider, error: 40 ? Could not open a connection to SQL Server) (Microsoft SQL Server, Error:) An error has occurred while establishing a connection to the server. (provider: Named Pipes Provider, error: 40 ? [...]