No, not for the server but rather for SQL Server itself.

I will note that you should ALWAYS set a MAXIMUM limit for the RAM the buffer pool can use to avoid unfortunately common memory starvation scenarios. The amount to...

I would like to mention that if you are going to use cursors (which can and should usually be avoided, btw) then in those cases where you just do a...

If you run your efforts in one script without explicit transactions then it is all ONE (implicit) transaction. This means that even in SIMPLE mode the tlog will grow...

I agree. And I would check both the SQL Server AND...

laurence.proctor (1/7/2010)

---

Thank you for your advice TheSQLGuru.

I have to agree with you (about Enterprise too). That said, I should have told the whole story. We do have a group of...

Here is the Bible for this area:

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

Note there are 2 follow-on blog posts for this.

I think that [long term] on-the-job mentoring by an expert (supplemented by personal study) is the best way to move from novice to apprentice to journeyman to master.

1) what is this "temporary data" you are removing?

2) what error messages are you getting?

3) is auto growth on and what it the setting?

4) how much...

GilaMonster (1/4/2010)

---

Please post new questions in a new thread in future.

If you look while the query is running, there will be at least one thread that doesn't have a cxpacket,...

You don't need Enterprise Edition here. What you DO need is to get a professional on board to review all of the details and configurations and then help you...

Cory, why in the world would you post a question to a forum thread that had it's last post over 2 YEARS ago?? :w00t:

I will add that the original release (and one of the subsequent updates to it) of SP2 for SQL 2005 had some significant problems with maintenance plans/agent jobs. You...

Dan Provan (1/5/2010)

---

Not sure if I'm a little late, and i ,must say that i only skimmed the post so if what I say has already been noted i apologize...

I have seen scenarios where stats needed to be updated multiple times a day to ensure optimal plans.