There is an index+PK on this field, of course.

The values are selected by the previous query and could vary every time.

The second similar problem is:

select value from tbl_value where test_id...

Thanks a lot - I just started to write my own script - you saved me bunch of time!

I'm doing conversion/upgrade involving a lot of old tables to be replaced by new ones or just deleted. It's a lot of time to find all FKs and then write...

The statistics were showing fine, but they were update with analyze command - old way of doing it... I run the new gather_table_stats and suddenly a miracle - the cost...

This is an Oracle query which I'm running from a DTS package to pull the data and feed my crystal report and staging tables.

Except what is the difference if it's...

This is the query from my initial posting. It's an old report and I cannot change anything else then the select statement, but it still need to return multiple resultset...

You cannot do this:

( SELECT COUNT(1) FROM Table2 WHERE v = Table1.Val ) != 0

- use a variable to assign it to or include the !=0 in the inner...

One more complication - I cannot replace the single query for the report with procedure as I was thinking. I can not touch the report and it needs a...

Everything will depend on the proper indexing. Generally, the inlist IN operator is not my favorite, although it works fine. I'm trying not to use "NOT IN" at all. "Exists/Not...

Hi Ganesh,

good morning to you too but I'm almost ready to go to bed...

This improved the performance - very good thinking. Thank you. In the same time, I redesigned the...

I do not like to use EM for this - you'll need with move option if these are not backups from the particular device.

Try to make yourself a restore DB...

Thanks, guys!

This is what MS confirmed but I was seeing something else going on...

If I tried to run the first query above, the activity on the remote server A was...

Thanks a lot, guys, for all of your input.

The problems my co-workers have with their new DBA are almost solved due to this posting and they have their...

Hi, I'm sorry for the delay, i had a virus attack at home...

Your script will work just fine, if you have the right logical names. ZRun restore fileoption -(check the...

This is a nasty error whoch appear when you have permission issues - you need SQL account to be an admin account on both servers. Make a search in MS website...