Check the SQL error log, there may be more details there.

just as a precaution, please run the following for the DB in question (during a quiet time)

DBCC CHECKDB (< Database...

SQL Server 2005 Express...

Gaby Abed (4/13/2009)

---

Changing planes in Amsterdam is not very stressful, provided you have at least a two-hour layover. I have a sister living there and sometimes, if the layover...

Management Studio Express is, as the name implies, just Management Studio, ie the client components. If you want SQL Server Express Edition, it's a separate download.

It's on the same page...

jcrawf02 (4/13/2009)

---

Damn Gail, I know you're in a whole different world coming from SA, and I'm just a spoiled brat living in the US of A, but what kind of...

Jeff Moden (4/12/2009)

---

I've been known to stop an interview after the first question for those same reasons. I've no tolerance for condescending or arrogant people especially where I work....

I stayed at the 7th Ave Inn last year. Decent rooms, includes breakfast (for the...

This is the way I always do it.

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

No point in tuning queries or indexes that aren't a problem.

radek (4/12/2009)

---

BTW: table like product_type, product,product_group,failure_cause etc.. is small max 2000rows and tbl_FAILURES_archive_only_first_entrys is about 4000, I think thats very small to create indexes but statistics is better concrete...

If you're going to make suggestions as to how something can be done, please...

Definitely not a good idea. Personally it's not something I would even suggest here as someone might use it without realising why it's a bad idea.

Multi-statement table valued function that...

No. It's $50. Buy it from Amazon if you don't have an MSDN subscription

And in case I have to...

How would...

Deadlocks won't cause timeouts. Deadlocks cause error 1205.

Timeouts at a certain time indicate that something else is running at that time that's interfering with the query that's timing out. Any...

Take a read through these:

Understanding Logging and Recovery in SQL Server

Managing Transaction Logs[/url]