Anything more useful in the logs?

got a backup you can restore from?

Calling in reenforcements.

What blog section?

aarionsql (12/5/2011)

---

Hi Jim,

Many thanks for your help. I should have mentioned I have gone down the route of CASE statements .. but there are far too many columns to look...

And the exact error is?

Was this db upgraded from 2000?

If there's corruption, checkdb will return an error, no doubt about that one.

Sounds like you have a lot more serious issues. What does this return?

DBCC CHECKDB ('db name') WITH NO_INFOMSGS, ALL_ERRORMSGS

Fridge, what's for lunch?? 😛

Jeffrey Irish (12/5/2011)

---

I have not received overtime for a very, very long time while I routinely work 55 to 70 hours per week, depending.

On the up side, we receive a...

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

chetanr.jain (12/5/2011)

---

@dev ..

Why should i manipulate the secen to make my life hell.... 😛

and question has come from the DEV team / support team only......

@Gila

This Sp is taking 27...

Jeff Moden (12/5/2011)

---

Ninja's_RGR'us (12/5/2011)

---

Jeff Moden (12/5/2011)

---

Uh huh... you might want to explain how that's going to work if you have data...

L' Eomot Inversé (12/5/2011)

---

That's startling. I don't have a modern...

It will still fail if there's absolutely...

Jeff Moden (12/5/2011)

---

Uh huh... you might want to explain how that's going to work if you have data missing from an...

The cpu% is rarely useful at that level.

THe proc needs to go from a to b... to z.

The only thing you can do to help here is to reduce the...