The easiest solution would be to save the query as a view on server ENIQSQLSERVER.

An...

-- make a table with two rows, two columns

DECLARE @t TABLE( ID INT IDENTITY, data VARCHAR(20))

INSERT INTO @t(data) SELECT 'Jacob'

INSERT INTO @t(data) SELECT 'Sebastian'

SELECT * FROM @t

GO

----------------------------------------------------------------------------------------------------

DECLARE @t TABLE(...

mallikachowdhary 98955 (7/24/2014)

---

Thanks Craig and Chris for the reply,

I have run the query on both the servers will post the execution plan once it runs, normally when running the same...

Compare the execution plans. Since the queries take so long to run, begin with the estimated execution plan. They will highlight differences between the two servers - say an index...

Check how many rows match:

SELECT a.dataid, x.Value

FROM TableA a

CROSS APPLY (

SELECT TOP 1 t.Value

FROM #tmpcopylibrary t

WHERE t.dataid = a.dataid

ORDER BY (SELECT NULL)

) x

TomThomson (7/23/2014)

---

No, he didn't...

At a guess, you have 741 duplicated rows, 73 triplicated, and 1 quadruplicated.

http://sqlinthewild.co.za/index.php/2010/04/27/in-exists-and-join-a-roundup/[/url]

-- Some alternative date arithmetic

SELECT

o.Forecasted_Commencement_Renewal_Date__c,

CAST(RTRIM(CAST(MONTH(DATEADD(mm, 1, o.Forecasted_Commencement_Renewal_Date__c)) AS CHAR(2))) + '/01/' + CAST(YEAR(o.Forecasted_Commencement_Renewal_Date__c) AS CHAR(4)) AS DATETIME),

DATEADD(MONTH,DATEDIFF(MONTH,0,Forecasted_Commencement_Renewal_Date__c)+1,0),

CAST((CAST(YEAR(GETDATE()) AS CHAR(4)) + CASE WHEN LEN(CAST(MONTH(GETDATE()) AS CHAR(2))) < 2 THEN...

wBob (7/23/2014)

---

I did trial that and honestly there is not a lot in it, with solution 1 (mine) slightly faster 5-10% on average at scale of 1 million. My...

Your first post shows Q1 and Q2 to be identical. If they are not, and you're obfuscating the code, then:

1. Why are you expecting them to execute in the same...

Lynn Pettis (7/22/2014)

---

Sort of like this:

IF OBJECT_ID('dbo.numbers') IS NULL

BEGIN

CREATE TABLE dbo.numbers ( x INT, CONSTRAINT PK_numbers PRIMARY...

murnilim9 (7/22/2014)

---

ChrisM@Work (7/22/2014)

---

-- change the index to support a nested loops join between rs and r

-- with seeks to r on id and residual predicate of RNT and Man:

create...

-- Make some sample data

DROP TABLE #SampleTable

SELECT *

INTO #SampleTable

FROM (

SELECT TOP 17 [Claim number] = 111, [sequence number] = ROW_NUMBER() OVER(ORDER BY (SELECT NULL)) FROM SYSCOLUMNS

UNION ALL

SELECT TOP 38 [Claim...