So you want something like this?

Customer Avg

1234 -2

2345 0.33

9999 ...

There's no 2000 equivalent for that. Your query checks the plan cache and retrieves the reads and writes for queries that have run in the past whos plans are still...

Probably IO_Completion or Async_IO_Completion

Most likely you have a mixture of badly written queries and inadequate indexes. There's no quick fix for this. If it's as critical as you say, you may be best...

Why do you want to detach the database when you close the app?

Please don't cross post. It just wastes people's time and fragments replies.

No replies to this thread please. Direct replies to:

http://www.sqlservercentral.com/Forums/Topic514284-145-1.aspx

Can you give us the expected output for the given sample data please?

Could you post the query that doesn't work on SQL 2000?

I won't call that perfect. Your elapsed time is still way higher than your CPU time.

Run the query in 1 window of management studio, in the other query sys.dm_exec_requests and...

Word of advice from someone who's been there. SQL 2000 does not play nice on Itaniums. I strongly recommend you consider upgrading to SQL 2005. It's a lot, lot more...

GSquared is right. I'm going through that exercise at the moment with a number of tables. You'll have to create a new table with the textimage where you want it,...

In general, the time difference between CPU time and elapsed time is the time that the worker executing that query spent waiting.

It may have been waiting for IO to be...

I seem to recall that the bcp puts a read lock on the tables. Can't remember if it's a table lock or if it locks pages at a time. The...

I had the 'pleasure' of working with a jdbc app a while back. From what I recall there is some property of the jdbc driver that determines whether things are...

I don't believe you can. SSIS packages are designed to run as scheduled jobs independent of users.

You may be able to write a small front end app that asks for...