BWFC (7/6/2016)

---

Phil Parkin (7/5/2016)

---

tindog (7/5/2016)

---

Michael L John (7/5/2016)

---

Can anyone in the U.K. (or is it K minus U these days?) make a recommendation for technical training? We have a...

In addition to everything Grant has said, it's worth noting that the performance of any query depends upon the accuracy of the information which SQL Server can obtain from it....

Grant Fritchey (7/5/2016)

---

If there are differences in structure, are there also differences in the amount of data? Take away different data types and different indexes (which makes comparisons impossible really),...

shirolkar.anand (7/5/2016)

---

Hi,

Please try using following code-

DECLARE @T TABLE (ID INT, NAME VARCHAR(1))

INSERT @T VALUES (1000,'A'),(990,'C'),(980,'A'),(970,'A'),(960,'B'),(950,'C'),(930,'A')

SELECT * FROM(SELECT ROW_NUMBER() OVER( PARTITION BY NAME ORDER BY ID DESC)ROWNUM,ID,NAME FROM @T )T

WHERE...

The expression LIKE 'UD1\%' is SARGable, meaning SQL Server can...

Can we have an actual plan from the fast query please? Thanks.

Here are some suggested improvements for your WHERE clause:

WHERE UD.EmployeeType IN (0,1)

AND NL.NetworkLogonId LIKE 'UD1\%'

--AND SUBSTRING(NL.NetworkLogonId, 1, CHARINDEX('\', NL.NetworkLogonId)-1)...

Raghavender (7/5/2016)

---

ChrisM@Work (7/5/2016)

---

Can you please add OPTION(MAXDOP 1) to...

Can you please add OPTION(MAXDOP 1) to the query...

Faulty logic. It's the maximum ID value which...

Raghavender (7/4/2016)

---

I have executed updatestats and updateusage on both the databases.

One observation is it is blocking it self.

I can see n number of processes with same SPID. In that where...

Sure. Run the CTE part and you will see:

select id, name

, row_number() over(partition by name order by id desc) as...

with ctenames

as

(

select id, name

, row_number() over(partition by name order by id desc) as rownum

,MAX(ID) over(partition by name ) maxid

from #name

)

select id, name

from ctenames

where rownum <=3 --Replace this with store...

Well done dandrews, and many thanks for the feedback.

dandrews 45259 (7/4/2016)

---

No Chris, if the Warehouse is BE for a works order record, its sales order is also a works order with its own related sales order.

072216 is a...

jagjitsingh (7/4/2016)

---

Hi

I have 1 query which returns record order by ID like this. Now i want that in addition to the below Query i want another query to group by...