Please read through this - Managing Transaction Logs[/url]

Rather stay away from join hints. By using them you're saying that you know the query and the data better than the query optimiser does. It may help today but...

Double check that the table is where it's supposed to be and has the right name. That looks...

Jeff Moden (6/18/2009)

---

Apologies to all... I got the SUM() OVER thing exactly backwards. PARTITION BY is the only part of the OVER clause that can be used. What...

John Doe (6/18/2009)

---

Temp tables are created in TempDB Database and require more IO resources and locking. Table variable is a memory structure. If it holds more data than it can...

I would take a long, hard look at that IO subsystem....

And a hell of a lot of time in Redmond.

Your database files are in a compressed folder/drive. Uncompress the folder and it should be fine.

Please post index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

You can also have a look at this blog post on the performance implications of scalar UDFs http://sqlinthewild.co.za/index.php/2009/04/29/functions-io-statistics-and-the-execution-plan/

Both temp tables and table variables are created in TempDB.

Please can you run the following and post the full results

DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS

I would guess that it's a hardware issue, specifically the IO...

I did public speaking for 3 years at high school. Was ok, I didn't enjoy it that much. Apparently some of the things they taught sank in.

What I've found, by...

Thanks. I need to play with both, but since I don't have an actual prod server to play with, it's going to have to be in a lab based on...

Are you sure that the server's SQL 2005 or 2008? The save-as will be greyed out if the server is SQL 2000. If that's the case, follow the steps for...

Short of cycling the log, opening the old log file in a text editor,...