Here is a script that covers various scenarios. I can't remember where I got it, but the author name is still attached.

/*************************************************************************

Author ...

You can try this article that shows how to do that.

http://jasonbrimhall.info/?s=duplicate+cte

Here's another script. This one provides a few different angles for helping analyze potential missing indexes. Use it in conjunction with one of the other scripts to try...

halifaxdal (8/18/2014)

---

SQLRNNR (8/18/2014)

---

halifaxdal (8/18/2014)

---

I like the word "handcuff", that's not by me, it's by the platform itself, I am building a...

kaplan71 (8/18/2014)

---

That is correct. All backups and a cleanup of older trn files are part of one Maintenance Plan.

The Differential backup of Friday night completed successfully. It was only...

halifaxdal (8/18/2014)

---

I like the word "handcuff", that's not by me, it's by the platform itself, I am building a dashboard using...

kaplan71 (8/18/2014)

---

The drive in question is connected to a SAN. The log file backups are being saved to the drive in question. I did further investigating, and there was...

You're welcome.

halifaxdal (8/18/2014)

---

SQLRNNR (8/18/2014)

---

So use a...

It's possible they are related.

Big transaction, running on slow disk, and getting deadlocked.

The IO errors could also be due to the wait for the transaction log to grow.

Hard...

So use a temp table.

Using...

No. A udf in that case clause would not be better. You are grouping by something that needs to be "calculated."

Instead, why not dump that information into a...

bologna

sgmunson (8/18/2014)

---

If only this were a question easily answered... The problem is that no one is likely to be interested in sharing any actual rate information, as...

Jpotucek (8/18/2014)

---

Running SQL Server 2000 SP4 and I started getting these errors in my log several days ago.

The log file for database 'tempdb' is full. Back up the transaction log...