Richard Bradford (7/2/2009)

---

I have experienced SQL 2005 64bit Standard Edition doing a similar thing as you describe especially when our data analysts are crunching very large datasets. The results are;...

Steve Jones - Editor (7/1/2009)

---

The DAC times out?

On a local connection, that is surprising. I think you might want to reboot the server, and if this happens again, perhaps hold...

Ok so it finally stopped - I let it run until it finished. Looking at the reports I have that show queries with high CPU usage, the offending query is...

Ok so this issue is happening again RIGHT NOW. I am unable to connect through DAC - it says timeout expired. There is very low disk I/O but cpu is...

I use DDL triggers on my databases here and they work great.

From what you posted, it sounds like there's something in your trigger that your application does not have...

Lynn Pettis (6/11/2009)

---

I'm pretty sure your requirements are more specific than what you have provided in your original post. If you could be more specific, provide DDL for your...

Florian Reischl (6/11/2009)

---

Avoid the inline query in your SELECT statement. You can use a row-number to work with a JOIN.

; WITH

t (Act, Dt, RowNum) AS

(

SELECT

...