My approach is I want the document to be idiot proof and to cover the exact steps to recover from a disaster.

If I get woke up at 2:00 AM, I...

I have never used the tool azcopy.exe before, but as a thought, does your SQL Server Agent account have permission to the Azure site and have access to the files...

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