Another thing on if the tempdb is growing unexpectedly and is growing rapidly. I outlined some methods to find the root cause of those growths. You will need...

Lynn Pettis (3/30/2010)

---

Jason, I read your blog post and I'm not sure what else I could add to your well written summary of the discussion we have been having on...

Fal (3/30/2010)

---

This QotD raises a point I'm always having to remind developers about, and I guess SQL guys can also do with a reminder from time to time.

However, my 2...

Nice question

WayneS (3/30/2010)

---

CirquedeSQLeil (3/30/2010)

---

If any are interested, I posted my blog on the topic. A greater bit of depth needs to be done with the topic. I figure this...

If the file is not there then somebody or some process has deleted if the backup completed successfully.

I would certainly verify that auditing is on for that fileshare and check...

Magy (3/30/2010)

---

The queries are all the same except for various AND statements.

So I guess I could do this?

SELECT * FROM myTable

WHERE 1 = 1

select case @myVar

WHEN 1 THEN

...

Have you tried using a left outer join for this query in lieu of the inner joins?

I would shrink the log file first. After the log file is shrunk an properly sized, then do the move.

Jack Corbett (3/30/2010)

---

Careful -...

sgambale (3/30/2010)

---

My tempdb, which hardly ever gets to over 10GB (almost all of it data), got to within 1 GB of the space limit on the drive it's on.

I wound...

Thanks for posting back.

Is this still an issue?

Lynn,

Do you have any other jobs or processes that may be trying to fire it off? I ask because I have a ton of jobs that are setup in...

10% fragmentation seems like an awfully low threshold. I've been in environments where we didn't touch it unless it was 50% (1TB plus databases). Then we would defrag...