How to execute long running SQL query or stored-procedure from .net 19. October 2015 Anil Kumar C# , MS-SQL , WPF Comments (0) SQL Server takes significant time to process (long running SQL statements) which leads to block the execution of your .net code i.e. main UI thread. [More]