jtallent-840140 (3/31/2014)

---

So yes, Phil's statement in the article reveals a degree of disrespect for the developer profession in general and could have been left out or worded more tactfully and...

Steve Jones - SSC Editor (3/31/2014)

---

There are entirely too many jerks in this business that still think women aren't as competent, and don't deserve the same opportunities, regardless of their...

What do you mean by 'not clearing space'?

If you mean the file isn't getting smaller, not it won't and it shouldn't. It sounds like you don't have enough space on...

Then I suspect that the resolution to this problem will involve locating another drive for TempDB or expanding the current one.

That script runs without error for me. Are you sure that's the exact statement which is throwing the error?

The arguments to CharIndex need to be in '', so there's no need to escape them. Anything inside '' is treated as a string literal. Can you post the code?...

Corruption in the system tables is severe. Restoring that month old backup may be a better approach than repairing.

You ran CheckDB with repair_allow_data_loss, and it lost data. That's what the command does.

The only way to recover is if you had backups from before the corruption occurred.

Yes, shrink is incredibly slow in some cases. There aren't really any tricks to it. You can shrink in chunks, you can stop the shrink at any time, it doesn't...

Short of running them in a similar environment and timing them, no.

I would disagree. If you love your job (which involves supporting the...

Cody K (3/31/2014)

---

I do knows some DBAs that fall into your criteria of learning a lot of technical minutiae quickly and even retain it. That's a cool skill to have....

Partitioning is unlikely to help at all.

Unless you can add some SARGable predicates (predicates where SQL can use indexes to reduce the rows it has to read), there's probably not...

Msg 156, Level 15, State 1, Line 1

Incorrect syntax near the keyword 'ORDER'.

Amusingly enough, while updates and deletes can take a...

The missing indexes are suggestions, not directives. If you try one out and find that it doesn't help the query, remove the index.