Replication, if it's a frequent need

Look at CREATE PROCEDURE in Books On Line (BOL)

We had performance issues after upgrading to 2005. Some of them were resolved after closely looking at the joins and finding we needed to modify or add the CONVERT functions...

You could use a maintenance plan, write each backup to a separate file as suggested, then use the cleanup task to delete the previous backups older than x days.

Based on your vague question, here are some vague answeers:

Not T-SQL, but ....

Replication

Log Shipping

Mirroring

Backup/Restore

T-SQL

Truncate table ....

Insert into ....

GilaMonster (10/24/2009)

---

Why do the columns have to be in a particular position? Why can't you add them at the end (which is a ALTER TABLE ADD ... command) and change...

Maybe you have differential backups or transaction log backups ?

I thought you only posted answers !!:-)

Is it a graphical plan ? Could you get the execution plan in text instead ?

Another option is to restore the database, then truncate all the tables. This can be difficult if you have a lot of referential integrity between tables because they need to...

Do you mean how do you get the new data in "B" back to "A" after "A" is back online ? I suppose that depends on how "A" and...

Michael Valentine Jones (10/20/2009)

---

homebrew01 (10/20/2009)

---

You could get a trial version of Redgate. Redgate also has a utility to convert their backups into "normal" backups, which you could do with...

Simple or full recovery model ? If Full, How often do you back up the transaction logs ?

You could get a trial version of Redgate. Redgate also has a utility to convert their backups into "normal" backups, which you could do with your trial copy in...

Some 3rd party tools allow specific table recovery. Some would have had to take the original backup with the tool. Apparently Redgate's latest version will do what you want...

Remember that the values returned from sys.dm_db_index_usage_stats are only accurate since the last SQL restart because they get reset to 0:

From BOL

"... The counters are initialized to empty whenever...