How to dispatch thousands of SQL requests asynchronously
We are writing a simple application: build thousands of SQL select statements run each select using BeginExecuteReader put the results into another database We've tried a few things that either leave connections in a SUSPENDED state (as verified by sp_who2), or take a much longer time to complete than just the SQL query itself (mayb...