I updated statistics with fullscan on noyau.patient table but I had the same problem if I ran the original query. It's not the solution.

Eric

Hello,

I just found the problem just before to get your email.

The problen is in clause WHERE with P.[pat_nom] IS NOT NULL. If I remove it the reponse time of query...

Hello,

I tried this :

DECLARE @p__linq__0 varchar(25),

@p__linq__1 varchar(9),

@p__linq__2 varchar(25),

@p__linq__3 varchar(9)

SET @p__linq__0=N'ARD%'

SET @p__linq__1='CHU-LYON'

SET @p__linq__2=N'REI%'

SET @p__linq__3='CHU-LYON'

SELECT

P.pat_nom,

P.pat_site_code,

P.pat_nom_naissance,

P.pat_id,

L.[lnai_id] AS [lnai_id1],

L.[lnai_cp] AS [lnai_cp],

L.[lnai_ville] AS [lnai_ville],

L.[lnai_pays_id] AS [lnai_pays_id]

FROM [noyau].[PATIENT] P

LEFT OUTER JOIN...

I adjusted datatype of myr variables to my column datatypes

DECLARE @p__linq__0 varchar(25),

@p__linq__1 varchar(9),

@p__linq__2 varchar(25),

@p__linq__3 varchar(9)

And created index

USE...

Jesus !!!

Query plan see attachment

Hello,

In this case, I return one line but anyway if the query returns one line or more the duration and CPU keep the same value.

Cheers,

Eric

Hello,

When I execute your script the result is wrong on schema_owner ?

IF OBJECT_ID('tempdb..#schemata') IS NOT NULL

DROP TABLE #schemata

CREATE TABLE #schemata (

CATALOG_NAME sysname...

Thanks guy you're fantastic.

Just a question I have some databases where the owner is " NULL" or " UNKNOW " :hehe:. Could I have some troubles with SQL Server...

The result is 1329861

4 millions from DI81SW (#TEMP1)

I have to insert 1.3 millions (#TEMP2)

I used the following script but I'm anxious because I have to insert 1.3 millions of line :doze:

I made some...

Yes all the time on DI628SW. DI81SW server linked

I ran the script on DI628SW

I got some errors.

1 - easilyPatId unknow (easilyPadId come from #temp2)

2 -target table ' DI628SW.NOYAU_PATIENT.noyau. TELEPHONE_PATIENT ' of the clause OUTPUT INTO cannot be next to a relation (primary...

I'm lost :doze:

The Data source I have to use for Insert is in Temporary table #temp2

Where is the link ?