I think it's because of where you're including the replicated 0's.

This will work:

DECLARE @MilDate VARCHAR(20)

SET @MilDate = '13:38'

SET @MilDAte = REPLACE( @MilDate, ':', '')

SELECT @MilDate

SET @MilDate = LEFT( @MilDate +...

I would agree that turning down parallelism should help with the worker starvation.

One other thing about VM boxes that I recently ran into is that you will want to talk...

Try using CAST( nTextField AS nVARCHAR(MAX)) = uniqueIDField.

It'll run like a three legged dog, but it should run.

mtillman-921105 (1/6/2011)

---

Zero, the way that we're discussing it, is more than just a placeholder - it means nothing. Spaces used to be used as placeholders, but, to me, that's...

I'd start with getting a straight count on the number of...

mtillman-921105 (1/6/2011)

---

Tom, in a conceptual way I sort of get the fact that zero divided by any other (real) number equals zero. But logically, I don't know why we...

GSquared (1/6/2011)

---

I dug around with a search engine a bit, and "sev3/sev4" refers to software support "severity level". There aren't standard definitions, but it appears that the higher the...

You missed some of Todd's sarcasm in that. You've given us very little to work from in terms of...

TravisDBA (1/6/2011)

---

Eric Russell 13013 (1/6/2011)

---

We can't expect a good result simply by wrapping process around un-trustworthy people. The fast food and financial industry have proven that. More can be done...

JayK (1/5/2011)

---

Eureka! So I finally solved the issue - just by trail and error.

When I set the 'Run as user' to 'dbo' in the Job Step it runs without an...

GilaMonster (1/6/2011)

---

Craig Farrell (1/6/2011)

---

Best way to start that research is get yourself a small partition on a drive (usually your C:\ is smaller), create a database, and fill...

vk24/7 (1/6/2011)

---

Craig,

I have not copied these q's from any site, these are the questions i was asked in the interview. I'm a newbie to this site and this is my...

WayneS (1/6/2011)

---

jcrawf02 (1/6/2011)

---

WayneS (1/6/2011)

---

Edit3: I'd like to go, if for no other reason than to hang out with Brent and Tim for a week and to be able to absorb...

CTE is a common table expression. It's a pretty way to write a subquery....

Koen (da-zero) (1/6/2011)

---

Craig Farrell (1/5/2011)

---

Of course, if you really want to mess with your own head, you can always assume because of graph charts and the like that -infinity =...