bitbucket-25253 (4/10/2010)

---

For those of you who expend a great deal of time / effort to share their knowledge of SQL .... here is one who really appreciaes your efforts. ...

Anybody who helps in solving there own problem should also be included. And those who take the time to give thanks for the help - they're awesome too. ...

Paul White NZ (4/10/2010)

---

RBarryYoung (4/10/2010)

---

Someone please tell me that this is not how Paul knocked out 3000 points in one month. I had ***-umed he was just racking up...

After re-reading the OP, it seems that the best plan of attack to me would be to migrate to SQL 2008 first and then add the new indexes. In...

Zauschneria

Good question.

Tom.Thomson (4/9/2010)

---

I think that would make the ferret throw up (if you feed it achovies on a bisuit with grated cheese and then spin it on a...

Tom.Thomson (4/9/2010)

---

CirquedeSQLeil (4/9/2010)

---

Tom.Thomson (4/9/2010)

---

A TSLOTALA would indeed...

Jeff Moden (4/9/2010)

---

rames.net (4/9/2010)

---

Seems to be a silly question but really the answer requires for me.

I have a small doubt, Generally when I got alert on tempdb log file size...

Not quite - they don't have quite the same elasticity.

They are much more effective for launching. Thus, I guess...

Tom.Thomson (4/9/2010)

---

A TSLOTALA would indeed be ideal,...

Did I hear that correctly¿?

Did your voice go up a couple of octaves when you said that??

There are several fine scripts in the script section here at SSC. I would browse through those, try a few and then use the one that you like best.

Fraggle-805517 (4/9/2010)

---

There is a tool that no one has listed and it is Free.

SSMS Tool Pack. Between this and SSMS 08, I essential get Redgate sql promt for free....

Unless absolutely necessary I would not mirror that many databases. I would pick and choose which databases were to be mirrored.