select OS.*

from #OLDSOURCE OS

inner join #NEWSOURCE NS on OS.CUSTOMERID = NS.CUSTOMERID and OS.CATEGORYCODE = NS.CATEGORYCODE

and OS. Startdate not between NS.startdate and isnull(endDate,'9999-12-31')

is Fc_hashbytes_sha1 a User defined Scalar function?

Also, do you need this?

WITH (INDEX(idx_unique_t_etl_xml_xref_uuid))

Also, this in a join condition cannot be good.

[FATCA_TDS].[Fc_hashbytes_sha1](UPPER(ISNULL(LTRIM(RTRIM(PARTY.source_code)), 'UNKNOWN') + '|' + ISNULL(LTRIM(RTRIM(PARTY.customer_number))

Is your collation such that you...

What would the expected results for this example be?

Here is a list.

Looks like they might compile the EndpointURL from bits in these queries.

SELECT

me.protocol_desc

, port

FROM

sys.database_mirroring_endpoints AS ME

...

Table definition?

Index definition?

Can you list the SQL services you have as well as whether they are running or not.

Jeff Moden (11/17/2015)

MadAdmin (11/10/2015)

Yes.

Because the DB was then able...

I see scalar UDF's in the where clause operating on a column and not a variable.

Convert the UDF to a TVF, then cross apply onto the TVF.

Not just any TVF,...

He is using the old ansi-89 style joins.

SELECT

tm.task_id

FROM

task_mstr AS...

What are the Buffercount, maxtransfersize and blocksize you use when doing backups?

Maybe link the script that is run.

Why do you keep posting questions which ask others to do everything for you?

We'll help with specific questions, as long as you keep your side of the bargain and...

Before you go out and buy books, I would first recommend the stairways first.http://www.sqlservercentral.com/stairway/72399/

Then once you know enough, Gail's http://sqlinthewild.co.za/index.php/2011/11/11/sql-university-advanced-indexing-indexing-strategies/

Creating indexes is a multivariable mathematical problem in maximizing performance while...

Does the query bring back data?

Does the query bring back data when using a login and user that has the same access rights as the login and user that executes...

WWOHD.

What would Ola Hallengren do?

I think it would be a good idea to get the index optimise script from Ola.

Using that, you can run the index optimise script with logging...

Yes.

Because the DB was then able to successfully serve...