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. 😉

Interesting that you mention Dataphor. There have been others that have been religous zealots about Dataphor...

That is a mighty big request, and there really isn't enough room here to fully answer what you have asked. One of the best things I could recommend is...

It would be better if you supplied the table and index information as DDL (CREATE TABLE and CREATE INDEX) statements. From your Excel spreadsheet it is a bit difficult...

Feel what? Variable names @d and @u may work in this example, but in a production environment it would not. There, variables and column names should have names...

Two things.

One, can you add a few more sample records that will cover all the cases you have described in your problem statement, for example, multiple transfers from the same...

honza.mf (11/18/2009)

---

Steve Jones - Editor (11/17/2009)

---

I have awarded back all points to people as of now. Apologies for the delay, but this was not the high priority of the day.

The...

Check out the following thread, it may help.

David Easley-401108 (11/17/2009)

---

I agree that the question is now better worded, but still disagree with the answer. Since the output of the queries is devoid of any timezone identification,...

Actually didn't get very far. I will admit to learning some things today. You'll find I spent a bit of time in the QotD world.

Almost time to get...

What you are attempting to do requires the use of dynamic sql. Please take the time to read about dynamic sql in BOL (Books Online, the SQL Server Help...

Paul White (11/17/2009)

---

Paul White (11/17/2009)

---

http://www.letmebingthatforyou.com/

(I...