L' Eomot Inversé (5/31/2012)

---

I drink some Dunkelweizen whenever I'm in Munich, ideally Schneider's Aventinus but it's not too much of a disaster if I accidentally go somewhere where they have...

SQL Kiwi (5/30/2012)

---

ChrisM@Work (5/30/2012)

---

This quaint snippet runs in (only) about 40% more time than the usual inline CTE tally table - which is itself no longer the fastest kid on...

jinkazama_11 (5/30/2012)

---

Thanks for your response

The total number of records can be more than 3, I can only use your query if there are only 2 records for one client.

I would...

jinkazama_11 (5/30/2012)

---

Thanks for your response

The total number of records can be more than 3, I can only use your query if there are only 2 records for one client.

I would...

If you want to make a rCTE run really quickly, then minimise the amount of "r" in it...

;WITH rCTE AS

(

SELECT [level] = 0

...

SELECT TOP 10 a.*, b.*

FROM MyTable a

LEFT JOIN MyTable b

ON b.ClientID = a.ClientID

AND b.SeqNo = 2

AND a.ClosureDate IS NOT NULL -- only join a row from b if closure...

SELECT a.SOURCE_FILE_ID, a.CYCLE_ID, a.TASK_ID, a.TASK_STATE_DESC

FROM #Sample a

LEFT JOIN #Sample b

ON b.SOURCE_FILE_ID = a.SOURCE_FILE_ID

AND b.CYCLE_ID = a.CYCLE_ID

AND b.TASK_STATE_DESC = 'Error' AND a.TASK_STATE_DESC = 'Setup Fail'

AND b.TASK_ID+1 =...

Charmer (5/17/2012)

---

ChrisM@Work (5/17/2012)

---

Before you ran the query, you ran "Display Estimated Execution Plan". How many rows were estimated for the insert?

If not, and if the source of the insert was...

Before you ran the query, you ran "Display Estimated Execution Plan". How many rows were estimated for the insert?

If not, and if the source of the insert was a select,...

The nearest I can get to that is a coffee stain on my copy of "SQL Server Execution Plans"! Great story Tom.

Having said that, Galicia's wines were amazing when the...

okbangas (5/16/2012)

---

A small update: The first index just finished, the second started off in parallel as it should just now. So, what I've learned from this situation: If your server...

opc.three (5/17/2012)

---

I can see where you would go there for indexes though you swept queries into...

opc.three (5/16/2012)

---

ChrisM@Work (5/16/2012)

---

Stewart "Arturius" Campbell (5/16/2012)

---

This is overridden using the MAXDOP as part of the index creation command...

Stewart "Arturius" Campbell (5/16/2012)

---

This is overridden using the MAXDOP as part of the index creation command and should,...

okbangas (5/16/2012)

---

Thanks for the information. I don't know why I have not already found this page. For the record:

* Resource Governor is not running

* Server CPU load is less than...