So if you have one SPID, but 700 rows, that means the server is trying to do parallel processing? They all show CXPacket.. So how do I track down whay...

I ran a trace.. and it added the following:

Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors.

dan-572483 (10/8/2013)

---

"Have you tried turning it off and on again?"

If you're able to schedule a downtime, do it. Simpley stopping the SQL Service and restarting will return the TempDB...

Gail, I had to create extra MDF's to deal with SGAM contention, so now I need to shrink the old file.

Bhuvnesh (10/3/2013)

---

IN two cases , size will not get reduced.

1) Shrink will not...

Thanks for everyone's help!

I modified the query so the columns will show if it is Arrived or In Transit, but the code works on my test... but not on my real data.

Error:

Msg 102,...

Man this is messy. Has MS fixed this in 2012? We are using 2005 and 2008.

This is as close and seems to work, now how would I show the Arrived .. In Transport. The columns are there.. Arrived first, and then In Transport, thanks to...

Thanks... yes this field is real simple.. just the code and description of the rail transport... So I tested the code on our data.. and it works great!

I used a CTE to cast the data... and it works, thanks for your help.... I was chasing the wrong rabbit.

;with Del_Ind as

(

SELECT Row_Number() Over(Partition by Purchasing_Doc_Num, Purchasing_Req_Item_Num...

Ok.. I guess the error I got was not due to the way I was doing it.. the test table I just created to post this worked.. so the data...

Erland Sommarskog (8/9/2013)

---

dwilliscp (8/9/2013)

---

Sorry should have added.. 64bit. Any change that would effect Disaster Recover, has to be done by the App Admin team. So I put in a request,...

GilaMonster (8/9/2013)

---

32 bit or 64 bit?

Have you enabled remote DAC? If not, you'll have to connect from the...

I am getting an error that DAC is not supported. I will...