80 MB is not large for TempDB. From the space used, it looks like it's only half used, which is fine. How big can it get?

If TempDB is sized properly...

Lookup Restore Database in Books Online. It will give you all the...

I would strongly suggest that you schedule the log backups to run at a regular interval (hourly is good) rather than basing it on the log's file size. The point...

Karl Klingler (11/7/2008)

---

Hi,

let's say you

rename the old log file,

then restore the db, diff and log backups

stop sql server

rename the new log file

rename the old log file to its...

Patrick Russell (11/10/2008)

---

I guess I hadn't thought of that. I actually try to stay away from dynamic sql. I always thought there where sql injection issues with it. Only use...

Marker (11/10/2008)

---

This DB is in Full Recovery mode. I'm backing up the Transaction Logs every 4 hours. If there was a catastrophic failure, 1 hour of lost data...

On SQL 2000 the only...

More correctly,...

What's the initial size? If you're using TempDB heavily, it must be changed from the default (2MB?)...

Firstly, read through these two articles:

http://www.sqlservercentral.com/articles/64582/

http://sqlinthewild.co.za/index.php/2008/07/23/recovery-model-and-transaction-logs/

What recovery model is this DB in (I'm guessing full) and how often do you backup the transaction log?

What is considered acceptable data loss for...

Can you post the query, the table with index definitions and the execution plan without the hint (saved as a .sqlplan file, zipped and attached to your post.)

See if you can open the file in a text editor. I've seen MySQL 'backups' in the past been nothing more than scripts to create and populate the DB. They...

I was trying to see how many sorts I could get in a single query. Answer,...

Seeing the code makes all the difference. It's not technically parameter sniffing.

That form of catch-all query does not perform well. Firstly the optimiser can't make accurate predictions with all of...

Patrick Russell (11/7/2008)

---

I have some procedures which i consider simple (joining 5 tables) returning mayby 10-12 records/with 3 columns. When I run the app, and it accesses this particular procedure...