Very Different Execution Times of SQL Query in C# and SQL Server Management Studio
- by Paul
I have a simple SQL query that when run from C# takes over 30 seconds then times-out every time, whereas when run on SQL Server Management Studio successfully completes instantly. In the latter case, a query execution plan reveals nothing troubling, and the execution time is spread nicely through a few simple operations.
I've run 'EXEC sp_who2'…