Saurabh Aggarwal (7/26/2009)

---

For eg if i am troubleshooting the slowmess of spid 55, which is still in running state and app team is saying that query taking long time...

Actually, you can get the plan of a query that has been run by the app or another user, providing the execution plan for that query is still in cache.

SELECT...

I suspect you're going to get a lot of hate mail for this one Brad.... 😉

Prices here range from R10 000 to R550, depending exactly what you ask for and what province you are in.

ITDPNDS may not be allowed in the US, but it is...

You've got data corruption and it looks like very nasty corruption.

There's damage to one of the system tables and that is not repairable in any way. Do you have...

Please run this and post the results.

DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS

That one has to be for Paul or Kimberly.

Jan Van der Eecken (7/25/2009)

---

GilaMonster (7/24/2009)

---

Jan Van der Eecken (7/24/2009)

---

On the way home there was a silver Audi A4 2.T driving in front of me whose owner's ego may well...

How did the database get detached?

Do you have a backup?

The recommended solution here is to restore from a clean backup. If you have no backup (why?) then we're going to...

Yeah. That's one very strange join condition.

Gangster's Paradise. :unsure:

Jan Van der Eecken (7/24/2009)

---

On the way home there was a silver Audi A4 2.T driving in front of me whose owner's ego may well be slightly overinflated. Personalised license...

Are you trying to change the value of another column in the table? If so, you need the UPDATE statement.

If not, can you give us some sample data and what...

Why don't you try them both and see?

No idea. Can you restore the backup file? That's the best way to see if the backup completed.