Try doing an update stats for each stats object on that table, one by one.

Probably, but it's a damn expensive app. Was over $1000 per...

In case you missed it

GilaMonster (8/15/2013)

---

As for shrinking TempDB, the recommendation is to completely quiesce the system before trying, by restarting in single user mode. Shrinking TempDB while processes are...

Since you've recovered the database, you can drop it and reconfigure the log shipping from scratch.

The secondary will be up to date as of the last log backup copied and...

If you selected standby, the database should be in the standby state. Recovering is when you select the NoRecovery status.

Standby's only if you need to read the database for any...

Plan cache and TempDB space are unrelated. No, removing plans from cache is not going to do anything about tempDB's size or behaviour in a shrink.

As for shrinking TempDB, the...

http://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/

Are there any relevant messages in the error log?

Mis-named user database files won't stop the instance from coming online. They'll only lead to the database in question being marked recovery_pending (not suspect)

It's master, model and TempDB that can...

Procmeister (8/15/2013)

---

- Once I've done that how does it work? Will I see new jobs setup? Is a new database created? Will I be able to get an email if...

May I suggest you use the built in log shipping functionality? Much easier.

Create a snapshot manually, check any messages in the error log.

Do you have any disk filter drivers installed?

To delete databases you would always log into SQL and do the delete from inside SQL Server.

I wouldn't suggest doing that. SQL manages the memory in cache just fine, and by clearing it you're removing any chance that pages needed by the night time work which...

Jeff Moden (8/14/2013)

---

If you buy the right disk defragmentation system, you can defragment SQL Server MDF, LDF, and NDF files while the system is up and running with little or...