Nope.

Good answer - go find backups.

Better answer - ask for help because this is out of my depth.

There are two numbers that I tend to use when making this kinds stuff up.

42 - the answer to the ultimate question of life, the universe and everything

137 - The...

😀

Good answers for that question:

* Look for help

* Call MS customer support

* Go look for my backups

Yes, I know...

falcon00 (3/16/2010)

---

I don't think you are discouraging me. I think you all bring up very solid points and allowing me to step back and evaluate my capabilities and look at...

Cool. It returns several lines of errors and the last two lines read.

CheckDB found 42 allocation errors and 137 consistency errors in database 'mydatabase'.

DBCC execution completed. If DBCC printed...

A restore recreates the DB exactly as it was at the time of backup. You can move the files around, you cannot create new files as part of a restore.

If they're pressing to urgently hire, it means they are desperate, probably means they have problems that they need solving. Not a good situation to walk into as a complete...

Is the sort a problem?

Is the specific query that you're looking at a problem?

You said it's not a poorly performing query, so why are you worried about it?

http://sqlinthewild.co.za/index.php/2010/03/11/the-root-of-all-evil/

More details needed. Perhaps you can take a step back and explain the slightly larger picture?

What defines which row of a table those values have to come from? Or are...

IF <conditions>

BEGIN

EXEC TheStoredProc

END

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic884158-1063-1.aspx

Does the company have a DBA? If not, and you have absolutely no DBA experience, I would actually recommend that you turn that job offer down and suggest to them...

823 is a hard IO error. SQL requested a read of the disk and the OS returned an error.

Clustered?

Is the disk available through windows?

Steve Jones - Editor (3/16/2010)

---

I've actually had to tell a VP to "go away" when I was managing. It was bad enough that I would go in to check on...

When restoring, you need full backup and all the log backups, starting with the first one after the full backup.