1) I recommend getting a book or two on administering sql server, or find a course or two to take.

2) with only 2GB on the server, if NOTHING else is...

Andrew Gothard-467944 (2/22/2010)

---

Your trousers would be terribly uncomfortable and weigh...

Thankfully those are some old dates there and (hopefully) newer machines won't have those problems! I personally don't have much of a warm and fuzzy about HPs firmware and...

There's a very good reason why you didn'g see the link, but...

Boy, if I had a nickel for every time I have seen this problem posted in a forum!! :w00t:

I use this article (and the two follow-on ones) as my Bible for troubleshooting/resolving deadlocks:

http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx

Some very interesting discussions on this thread - wish I had had the time to pop in before it had run it's course!

By the way, I have definitely seen this...

Glad you were able to resolve your problem! Seems there really is a reason it is 'required' to make sure your firmware and drivers are topped off! I...

But in order to do things that are done in many...

Ol'SureHand (2/18/2010)

---

Pity no resolution note is visible ...

Just discovered this happening on our brand new SQL2005 64-bit Standard installation.

Every morning at about the same time IO takes longer than 15...

mansshah (2/18/2010)

---

Hi,

I am facing similar issue while inserting lots of rows into the SQL server 2005 database.

My through put from the Sql server is 400 rows in...

1)...

Animal Magic (2/18/2010)

---

TheSQLGuru (2/17/2010)

---

sanketahir1985 (2/17/2010)

---

Hii

Do not change any configuration settings without having the root cause why RAM is getting utilized. ByDefault sql server uses available RAM.

2ndly run the...

sanketahir1985 (2/17/2010)

---

Hii

Do not change any configuration settings without having the root cause why RAM is getting utilized. ByDefault sql server uses available RAM.

2ndly run the perfmon in peak...

Tara-1044200 (2/17/2010)

---

I want to update memkey,state and empno in table Emp_CA where memekey is found with null value. these 3 columns should be updated from the table OBBEAVER.dbo.memberlist whic also...