<div>
let me know if the comment was helpful
</div>


<div>
How can i check what is an 'unnecessary ' dependency?
</div>


How can i check what is an 'unnecessary ' dependency?

<div>
Great thanks, that did help.
</div>


<div>
<div class="content wysiwyg-content">
I have a SPROC, nothing to crazy...few sums and 2 joins.<br />
<br />
In query analyzer, it takes .0 seconds to run. From code, right on DataAdapter.Fill(myTable).<wbr /> 20 seconds or times out. <br />
<br />
Not sure what to do from here aside from the obvious which I have checked (indexes, etc).<br />
<br />
Thanks for help.
</div>
</div>


I have a SPROC, nothing to crazy...few sums and 2 joins.

In query analyzer, it takes .0 seconds to run. From code, right on DataAdapter.Fill(myTable). 20 seconds or times out. 

Not sure what to do from here aside from the obvious which I have checked (indexes, etc).

Thanks for help.

Query Taking LONG time with DataAdapter.Fill

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.