A connection to a database is a resource intensive operation that typically comprises a few steps. A channel of communication between the application and the database should be established before the ...

Use profiler.<br><br>SQL leaves them open for a time for the connection pooling of course. -- View image here: http://episteme.arstechnica.com/infopop/emoticons/icon ...

Using COM+ pooled objects to cache and reuse valuable resources is one of the most effective ways to boost performance in server-side .NET and COM-based applications. Database connections are among ...

Leverage ADO.Net's ability to work in disconnected mode to enable your application to stay disconnected to the database, conserve the system resources, and reduce the network traffic Microsoft’s ...