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

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