Authorization on those by account or by group?

Can you provide a sample of the XML? Anonymized, of course. That would make it easier to see what's going on.

I can't tell what you're asking for.

Nope. No progress bar available. Not really possible, either.

You can get an estimated "cost" of a query, which can roughly translate to duration. But the "costs" are...

Tao Klerks (7/19/2012)

---

Lynn Pettis (7/19/2012)

---

Two, on this "The Imperial system works; the metric system works better", whose definition of better? What makes it better? Or is it just...

Mad Myche (7/18/2012)

---

The correct answer is to store in UTC. Databases store data, and it's the job of whomever is getting the data to present in the correct format.

As for...

No they're not. It's easy to make nondeterministic scalar UDFs.

Are you using Select From OpenQuery? If so, you can do the date conversion in your Select clause.

Have you made sure SQL Server, SQL Agent, et al, are all running/starting under some other credential and won't lose access?

Two types. Deterministic and non-deterministic.

In other words, what do you mean by "types" of functions?

bpw (7/19/2012)

---

Thanks for your prompt responses.

@colin - I implemented this and the time cam down to around 16mins, which is a big improvement, thanks.

@yayomayn - I'm concerned by what it...

paul.knibbs (7/19/2012)

---

BenWard (7/19/2012)

we can track how fast they drive vs speed limit on the roads they are on and the g-forces caused by their cornering and acceleration to see if...

yayomayn (7/19/2012)

---

Another thing you may want to consider is adding in some sort of check to see if the columns actually have different values. I use CHECKSUM for this....

[Code="sql"]

WHEN

MATCHED...

If you execute multiple scripts on multiple connections, they can block/deadlock each other, just like any other scripts. But if they're sequential in one script, and you run it...

Probably. I'm not as familiar with script tasks in SSIS as I probably should be. But why not get your SSIS package assigned a credential with bulk-import permissions?...