Alvin Ramard (11/18/2009)

---

Jack Corbett (11/18/2009)

---

Alvin Ramard (11/18/2009)

---

Lynn Pettis (11/18/2009)

---

You mean...

Jack Corbett (11/18/2009)

---

Thanks, now you got me sucked in. I agree with...

CirquedeSQLeil (11/18/2009)

---

Lynn Pettis (11/18/2009)

---

But guys and gals, I strive for those lonely souls who just haven't seen the light, the joy when the cfl finally comes on is so fulfilling!...

You mean I have been hitting my head against a...

But guys and gals, I strive for those lonely souls who just haven't seen the light, the joy when the cfl finally comes on is so fulfilling! 😉

True, but I really want to see how (or if) he will respond to Bru's and my posts. If he does, how he does will determine how much effort...

Bob, You know me, I can't just walk away, permanently that is. I always seem to go back and try and help. 😉

How about Desert Vacation? 😛

ARRRGGGGG!!!!!!!

I really need to go out to the desert!! Anyone want to join me??

forumdog (11/18/2009)

---

I shouldn't have to say it. It is assumed. My requirement was what I stated. For you to assume otherwise is just being unhelpful and being difficult. Be a...

forumdog (11/18/2009)

---

Alot of very rude and what appears to be blatant disrespect and rudeness so far. Okay you arrogant and unhelpful people. May life and God show as much caring,...

Why are you using SQLCMD to run your backup? You can do it just as easily in SQL.

Can't help you with what you have posted. We really need to see ALL the code not just the subquery you are working with.

For the query posted, based on the execution plan and the indexes I saw, I really don't see anything else you can do. The nonclustered index is a covering...

A guess? With 43K rows, say about a second or two. Obviously a big improvement from the RBAR (while loop) method originally used. 😉