Viewing 15 posts - 46,291 through 46,305 (of 49,571 total)
So you want something like this?
Customer Avg
1234 -2
2345 0.33
9999 ...
June 10, 2008 at 9:07 am
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...
June 10, 2008 at 9:04 am
Probably IO_Completion or Async_IO_Completion
June 10, 2008 at 8:59 am
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...
June 10, 2008 at 8:55 am
Why do you want to detach the database when you close the app?
June 10, 2008 at 8:41 am
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
June 10, 2008 at 8:40 am
Can you give us the expected output for the given sample data please?
June 10, 2008 at 8:34 am
Could you post the query that doesn't work on SQL 2000?
June 9, 2008 at 3:12 pm
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...
June 9, 2008 at 3:10 pm
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...
June 9, 2008 at 3:03 pm
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,...
June 9, 2008 at 2:55 pm
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...
June 9, 2008 at 2:24 pm
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...
June 9, 2008 at 1:39 pm
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...
June 9, 2008 at 1:17 pm
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...
June 9, 2008 at 1:14 pm
Viewing 15 posts - 46,291 through 46,305 (of 49,571 total)