My advice is to not do an in-place upgrade.  The benefits of an in-place upgrade are that you don't need to change any connection strings in your applications and it...

Thanks Jeffrey!  You are right.  My query is not going to work due to the comparison on Column1.  My query would have only returned rows that had Column3 = MAX(Column3)...

I think this may be by design.  A normal user generally shouldn't need to run any sys stored procedures as those are more aimed at a DBA.

If you REALLY need...

Ken, get well soon!

You need to get to HAL9000!  Only 8996 more HAL's to go.

My opinion - those are 2 distinct problems.  First being searching of Word documents and the second being searching user text stored in MySQL DB.  If the word document is...

oh nice.  Then it is likely already sorted, so the query I gave SHOULD give you pretty good performance.

My opinion, that is likely the best you will be able to...

If the function is just a MAX, I would change the query to be something more like this:

DECALRE @maxValue int;
SELECT @maxValue = MAX(column3)
FROM Schema1.Object2

SELECT Object1.Column1,
  ...

There is always something; it is just what you are willing to do.

Selecting fewer columns can improve performance, removing functions can improve performance, reducing the result set can improve performance.

Fewer...

I am assuming you are importing a flat file into SQL Server via SSIS.  If so, the limitations I know of are only based on the amount of memory you...

For others who want to help without downloading, here is the query:

USE Database1
set statistics io on;
set statistics time on;
 
SELECT
Object1.Column1, 
Object1.Column2, 
Object1.Column3,
Object1.Column4,
Object1.Column5,
Object1.Column6,
Object1.Column7,
Object1.Column8, 
Object1.Column9

FROMSchema1.Object2 Object1
INNER JOIN  ...

Just to add a small little bit to what everyone else said, the user may map to the login with a different name.  For example, the user may be named...

Joe, some of the stuff you said I agree with, but some of that was a bit uncalled for don't you think?  "Perhaps you should read a book?".  Looking at...

At my workplace, end users are not allowed to connect to the LIVE systems via excel.  We don't have any specific rules restricting this, but we advise the analysts not...

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