-- Note the use of aliases to reduce noise and make your query more clear

-- avoid right joins, most humans can't read them

-- don't put a column from an outer-joined...

It took seven years? Should've gone to Specsavers for a better...

Eirikur Eiriksson (8/14/2015)

---

Jeff Moden (8/14/2015)

---

Eirikur Eiriksson (8/14/2015)

---

Ed Wagner (8/14/2015)

---

Eirikur Eiriksson (8/14/2015)

---

Alvin Ramard (8/14/2015)

---

Eirikur Eiriksson (8/14/2015)

---

SQLRNNR (8/14/2015)

---

Eirikur Eiriksson (8/14/2015)

---

Sometimes one wonders what drives the responds when one points out that the...

It depends...

Check the definition of index [_dta_index_ EFT_AR_AP_Snapshot_11_13…] on table [EFT_AR_AP_Snapshot] is the same on both servers. This is based on comparing seek predicate and residual predicate between the two...

tfeuz (8/14/2015)

---

All;

Thank you for all your responses. As most of you alluded to, I went down the path of checking out the query plans and the indexes.

After ensuring that...

nick.latocha (8/14/2015)

---

Hi,

Fairly new to managing large datasets - we have a large table - 16m rows.

We load around 800k rows each month and store data on a monthly basis.

We...

Run this and you will see what I mean:

SELECT a.ID, b2.EMPID, Grp

FROM #a a

CROSS JOIN (

SELECT empid, Grp = ROW_NUMBER() OVER(ORDER BY MIN(ID)) FROM #b GROUP BY empid

) b1

LEFT JOIN...

Anamika (8/14/2015)

---

Hi,

I appreciate your response. I need little more info if I add some more records in B like

INSERT INTO #B VALUES (4,'E2')

INSERT INTO #B VALUES (5,'E2')

then the...

SELECT

a.ID,

b2.EMPID

FROM #a a

CROSS JOIN (SELECT DISTINCT id FROM #b) b1

LEFT JOIN (

SELECT ID, EMPID, rn = ROW_NUMBER() OVER(PARTITION BY ID ORDER BY EMPID)

FROM #b

) b2 ON...

Any time, thanks for the feedback.

Can't tell from your code, but probably because you weren't comparing your expression to anything:

(CASE...

Sorry, I didn't realise how new you are to SQL.

SELECT column1, DATENAME(weekday,column1)

FROM #table1

WHERE...

-- Make some data to play with

DROP TABLE #table1

CREATE TABLE #table1 (column1 DATETIME)

INSERT INTO #table1 VALUES (GETDATE()-1),(GETDATE()-2),(GETDATE()-3),(GETDATE()-4),(GETDATE()-5),(GETDATE()-6),(GETDATE()-7),(GETDATE()-8)

/* Take a peek

SELECT column1, DATENAME(weekday,column1)

FROM #table1

*/

GO

-- Pretend it's monday

DECLARE @getdate-2 DATETIME = GETDATE()-3

DECLARE...

Let's get this clear.

If today is Monday, then you want to return data for Thursday, Friday and Saturday.

If today is Tuesday, Wednesday, Thursday or Friday then you want...