As this is a SQL Server forum, you likely wont' get too many replies.

Posting to MySQL or AWS may get you better results, but my guess is that there is...

My opinion is that it depends.  How much downtime is acceptable being the biggest question.

Let's say the server completely dies on you one day; it just won't power on anymore. ...

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, 2 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)...