Jeff Moden (1/29/2010)

---

Unless a table is nothing more than a temp table, I put clustered indexes on all tables as a matter of rote. That way, I don't have...

Heh...

Lynn Pettis (1/29/2010)

---

WayneS (1/29/2010)

---

Lynn Pettis (1/29/2010)

---

.... You should also script out all jobs in msdb. Probably all the logins (sans passwords) in master as well. You will...

Thanks for updating us. As Michael pointed out, make sure you get some good backups of your databases and keep them in separate physical locations / media.

Is it alive? Anybody have a defibrillator?

No.

Do you have a backup of the master database?

A restore of the database is imminent.

You're welcome.

crookj (1/29/2010)

---

In full agreement! Baseball and basketball...

You could do this at the application layer. Using the same code for each connection, performance v. linked server should be negligible. The use of the BI tools,...

Have you considered replication for this scenario?

Of course, since you are writing the application to perform the insert, you could also have it insert into the subsequent databases using the...

What timing? I will repost that answer in the other thread.

have you considered replication?

Depending on the scenario, table variables could be better than temp tables. The same is true of temp tables being better than table variables. No single type is...

delete

dbo.table1

from dbo.table1 as source

Inner Join dbo.table2 as dest

on dest.id = source.id

Is an...