And nested cursors don't scale very well at all.

If you provide the info requested, we could probably provide you with a much more scalable and mainatainable set based solution.

GilaMonster (2/17/2010)

---

and DBAs know...

I catch it on my...

Sheep, goats, and wet suits. Definitely interesting...

First, you really should look for a set-based solution to this problem. The cursor-based just won't scale well. We don't have enough info to help you write a...

Alvin Ramard (2/17/2010)

---

Lynn Pettis (2/17/2010)

---

Alvin Ramard (2/17/2010)

---

Changing subject for a second.

A wise person once told me:

[font="Comic Sans MS"]"Do not argue with a fool. People may not know which...

CirquedeSQLeil (2/17/2010)

---

If it is a crisis and the databases are down, it serves nobody to finger-point. Server Team, Admin Team, SAN Team, and Database Team (occasionally development team) had...

Pretty...

Shoot-Ready-Aim must work in a perfect environment where the right people always know when things go wrong and communication actually works the way it should.

GT-897544 (2/17/2010)

---

Lynn Pettis (2/17/2010)

---

GT-897544 (2/17/2010)

---

If failure was at I\O SAN controller level, Server Team had already told you before you go to check SQl server error logs that it is...

If the table is 1 TB in size, you will want to break the update into chunks or you could end up locking the entire table during the update.

Some idea...

cmallain (2/17/2010)

---

Alvin Ramard (2/17/2010)

---

cmallain (2/17/2010)

---

Or...has anyone considered that some of us do not know where to look and with being thrown into situations really do not have the time...

cmallain (2/17/2010)

---

Or...has anyone considered that some of us do not know where to look and with being thrown into situations really do not have the time to do the...

Just looked here: Anything that is NOT about SQL!

Looks like the DBCC Timewarp thread is just gone. Curious, can it be recovered?

GT-897544 (2/17/2010)

---

If failure was at I\O SAN controller level, Server Team had already told you before you go to check SQl server error logs that it is hardware failure, Even...