You say you have tried things and are looking for answers that are "better than" yours.  To avoid us posting identical things than what you already have, could you post...

Also, my brain was thinking about that wrong.  What DinoRS put is correct in that "Or in other words: Show only results where you have more than one resultset available.". ...

Does this need to be in SQL 2008?  Solutions in newer SQL versions make this a lot easier.

EDIT - if this NEEDS to be in 2008, I did this in...

• This reply was modified 5 years, 10 months ago by Mr. Brian Gale.

DinoRS, if I am reading that query correctly, isn't it saying "show only results where you have less than 1 result set available" not "more"?

The WHERE clause is saying "WHERE...

So converting this I am a bit rusty on Oracle, but I think this is going to be similar (although not 100% certain as I have no sample data or...

If you'd like more information on indexes, I highly recommend Kendra Little's blog:

https://sqlworkbooks.com/blog/

Kendra is my "go-to" person for indexes!

Brent Ozar has a blog post on it with Kendra Little too:

https://www.brentozar.com/archive/2011/09/kendra-little-explains-how-design-smarter-indexes/

Close... My expectation is it isn't taking precedence for one over the other, it is configured to use one over the other.

When SQL was installed originally on the old server,...

I am in a similar boat and have created my own "wishlist" as I've started calling  it as it is hard to get buy-in from non-technical people.  But I'll try...

Adding non-clustered indexes depends on the query being executed.  Generally, you want to look at the WHERE clause or the ORDER BY clause and anything those are filtering on will...

Yep, I agree with you Jonathan AC Roberts, but what if the number of columns is dynamic?  With version 1 it has 3, version 2 has 2, version 3 has...

Not sure that an index will help anything since there is no WHERE clause or ORDER BY.  No matter what index you put on there, it is going to be...

It depends.  Are you needing to change who it connects as?  Are you needing RPC?

My advice, try it out.  Make the linked server and see if it works for you. ...

On top of the SQL checks, I would be doing a chkdsk on the system as well.  Don't want to find out that the physical disk (OS and SQL disks)...

I think you are mixing some things up and getting confused.  A LOGIN FAILED message in the log means that a login was attempted but was not successful.  The CLIENT...

That bit of code looks fine to me.  What I'd recommend is posting an execution plan.  That will likely be the best bet to figure out why it is slow.

How...