Not directly.

Restore the backup as a new database and use UPDATE to get the values as you want them.

Not that I'm aware of, from the output of the repair.

Do you have the original error messages?

Why repair and not restore from backup?

gary.wood (8/28/2009)

---

Well, thanks, but as I mentioned, this is greatly simplified and the real WHERE clause is significantly more involved. I picked this one simply to illustrate what I...

And be aware that ISNUMERIC checks whether the value can be cast to one of the numeric data types, not whether it can be case to int.

SELECT ISNUMERIC ('1.245d10')

SELECT CAST('1.245d10'...

Not so far, no.

I'm sure I've mentioned it before. http://clippings.mozdev.org/

Maxer (8/27/2009)

---

I wonder... if one of the tables had a clustered index on NAME and the query was

SELECT Department, Name

FROM someTables

ORDER BY Department

Then is it at all possible that...

GSquared (8/28/2009)

---

He actually insisted that dressing well helps to prove competence. Not, "dressing well shows a degree of respect for the people you are interviewing with, and a conformation...

I'm not familiar with the x5570 and I'm not as familiar with NUMA as I would like to be. As far as I know, a NUMA node would consist of...

Good to hear.

This means if the IO subsystem problem can be resolved alongside putting in place...

mazzz (8/28/2009)

---

at any time, or just at work?

I now have...

There's...

He also insisted that anyone who dressed casual or semi-casual was ignoring reality and would never get a top job

SQL from 2005 onwards handles the NUMA architecture just fine. However, with 4 cores (how many physical processors?) and 6 GB memory, I don't see how the memory can be...

Is there a question here? Are you concerned about the backup file size and, if so, why?

Full database backup or log backup?

How big's the data file? How much of the...