I am sure there are a lot of ways, but my approach is to check each individually.

Perfmon will tell you quite nicely how much CPU  SQL Server is using compared...

I think this falls under an "it depends" scenario.  If the users are logging in with a generic account and that is all the information that SQL Server has, then...

Try changing the SQL Server Agent startup type to "automatic (delayed start)" to make it start after SQL Server.

I personally have never needed to do that, but I have with...

I personally don't know MySQL, but I think it really depends.  To change the order of the columns, you change the order of them in your SELECT.  For example, if...

I like Jeff's approach here, but my preference when moving large amounts of data from table A to table B on a different database is to do it outside of...

I do not know of any forum similar to this for MySQL.  I do not use MySQL myself.

But I think your query for the most part should translate between the...

The worst part about the tools is licensing.  That is such a pain in the butt.  MSDN (visual studio subscription I think is the new name) is a GREAT example...

So that is progress, but still 2 issues.  First - there is no sample data.  Second - that is not Microsoft SQL Server code.

But, from looking at what you posted,...

My approach, looking at it, you are wanting all rows where there is an IN followed by a SOLD.

For a start with your WHERE clause, filter out all rows where...

If it is in an SSIS package (ie the job step calls an SSIS package and is NOT calling direct TSQL), you should have no issues as the SSIS package...

If memory serves, they will not show and will need to be re-created.  This is easy to do if the old server is still online and you know which jobs...

From reading the error, it sounds like it is telling you exactly what is wrong - you are sending an NVARCHAR datatype and it requires a VARCHAR datatype.

Not 100% certain...

First, I could be mistaken, but that does not look like SQL Server code.  Is that MySQL or PostgreSQL?

Secondly, that screenshot is not "consumable" by us.

Third, the screenshot only shows...

It is as ratbak says, excel files don't help us.  We have no easy way to take an Excel file and create temp tables from it.  Plus, the excel file...

If you provide some DDL and sample data, I'm sure someone can help.  With what you provided (excel not tested as that is always risky), we have no way to...