I feel compelled to add that replication is an ADVANCED topic. Almost every 'regular user' out there that tries to implement it goes astray - often with really bad...

Key point that many miss:

If you do a REORG of index, you MUST update the statistics manually.

If you do a REBUILD of index, you must NOT update the statistics manually...

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...