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...

Another reason for SQL Server Agent issues is if you are running SQL Express.  SQL Express doesn't support SQL Agent.

But, as John Mitchell suggests, check the logs.  Also, check the...

the users in a database are contained in the single database.  There is no way (that I know of) to get all of the users in a database without using...

I think that won't work unfortunately.  SQL is being helpful and pulling the data out of master when you query against sys.sql_logins.  You can verify this by switching to any...

Could you post the exact error message?

I have links all over the place with different SQL versions (ranging from 2008 R2 to 2016) and everything seems to work without  much...

I went a slightly different route... I used Jeff Moden's DelimitedSplit8K function to do this...  (some of the bits are just intermediary calculations)

SELECT ft.RawValue
, ca.ItemNumber
,...