I disabled "auto-close" but it makes no difference.

The GUI is still reacting very slow as are any other connections to the DB.

Any further help will be greatly appreciated.

Thanks

My CPU Usage is on average at 20%. System Idle Process: 97 then : iexplore, OUTLOOK.exe ...  The rest seem fine.

The auto-close db option is set to ON.

I have already checked. SQL Server takes up the most memory with 21mb. After that it's just the normal iexplore (18mb) and explorer (15mb).

No other processes seem to be causing...

Thanks for all your input.

We did a rebuild of all the indexes and the queries seem to be running a bit faster.

I have a feeling that there might be some...

To answer your question, Jeremy, a backup from SQL 6.5 cannot be restored in SQL 2000.

That's why we had to script the database.

Thanks Hirenk, I'll try your suggestion. Do you...

Hi Steve

The use of DISTINCT won't work since

the record where

Accounts.Acc_Type = 'ALL' might be matched before Customers.Acc_Type = Accounts.Type is matched and then the 'ALL' will be displayed due...

Matthew, I cannot change the clustered index to another column as the line_id column is the only true incremental column in this table. I am not familiar with the use...

No, Matthew, you actually did understand the requirements correctly. It was my test data that was not complete, that's why GBN's solution worked at the time. I replaced it with...

The execution plan indicates that 86% of the processing is on the "Clustered Index Scan" on both TableA and TableB. That being the LINE_ID columns on both.

Should I change the...

Nope, does not work. I put indexes on all the columns used in the join and the query still executes for 7 min.

J

Great stuff.

Both the solutions that DavidBurrows and GBN gave work well. The performance is a bit better on GBN's solution though. Must be the fact that there is only one...

Well, looks like there is no shorter way of doing this. Thanks for the input, Matthew.

J

Thanks NPeeters, you are absolutely correct about the use of the ISNULL. I created this sample SQL in quite a hurry. But anyway this not part of my real problem...

Thanks for the help. I am still hacking away at the problem.

Thanks, but that will not work. It will still give me two results. What I wan't to happen is a test for the first condition and if the condition is...