SQLQuest29 (11/2/2012)

---

sqldba_newbie (10/30/2012)

---

I have gone through many many different forums in trying to identify my tempdb issues. None of the queries are giving me the data i want. Basically...

CREATE TABLE #Sid

(

...

GilaMonster (10/30/2012)

---

The log is a circular file, SQL writes log records until it reaches the end of the file, then cycles round and starts reusing the file from the beginning.

Managing...

GilaMonster (10/30/2012)

---

TempDB is in simple recovery model, Backup log with truncate_only does nothing to a DB in simple recovery.

When shrinking a log file, you can't shrink past the active portion...

GSquared (10/30/2012)

---

I'm not clear on what you're asking for help on. I see the code, I see you want to do something in a Join statement instead of "at...

GSquared (10/30/2012)

---

sp_who2 should tell you which SPIDs are active in tempdb. Can use the Management Studio activity monitor (right-click the server name in the object explorer if you haven't...

any thoughts?

ChrisM@home (10/28/2012)

---

Where in this code do you populate table #sid?

sqldba_newbie (10/28/2012)

---

My goal here to apply the condition to the query while joining the table instead of doing it at the...

please move this to appropriate forum..

shows as NULL

wait_type = NULL

wait_time =0

last_wait_type=SOS_SCHEDULER_YIELD

wait_resource= [blank]

status=running

GSquared (10/25/2012)

---

Not just CPU from that SPID. Overall CPU use for the server. Can "hang" a query just waiting for CPU resources. Check what your wait-types are...

GSquared (10/25/2012)

---

Periodic hardware over-use?

Really can't tell from what little you've posted. Not sure what you'd have to post to help. Sporadic, no-repro issues like that almost always require...

SQLRNNR (10/22/2012)

---

sqldba_newbie (10/22/2012)

---

Vegard Hagen (10/22/2012)

---

Most likely you've come across a piece of bad application code that doesn't clean up after itself.

All temporary objects created in tempdb must be dropped when...

Vegard Hagen (10/22/2012)

---

Most likely you've come across a piece of bad application code that doesn't clean up after itself.

All temporary objects created in tempdb must be dropped when you're done...