I have a large (>1M records) table in MS SQL Server 2000 with values that need to be updated. Changing the values in the table and using the Update method of DataAdapter works, but takes nearly 10 minutes. Using a similar query and executing from Query Analyzer takes under 15 seconds. Why the huge discrepancy? Anything I can do to mitigate the problem?