I had an issue today with an ASP.NET application not able to connect to my SQL database, it turned out to be an issue with connections not being closed down properly, I used the following SQL code to check for the open connections: 39 more words
Tags » SQL
The test plan is create at the execution of the SQL Statement.
The Test plan defines how this SQL query is executed internally. The Test plan contains the Index Seek or Test scan. 680 more words