I have to agree with SQL Guy 1 above.

Define "Move Data". One shot vs. continous vs. scheduled. Mirror/snapshots, Transactional Replication, Backup/restore, Log Shipping, Bulk Data Files, and scripting...

Luis Cazares (6/2/2014)

---

Would there be any good reason to deny it? I can think of many benefits but I don't know if there are any drawbacks. This is a fight...

BST? Either way, where...

SQLRNNR (5/30/2014)

---

Steve Jones - SSC Editor (5/30/2014)

---

SQLRNNR (5/30/2014)

---

Steve Jones - SSC Editor (5/30/2014)

---

Everyone enjoy summer. Last chance to ping me for things before I'm gone for 6 weeks.

7 hours and...

Steve,

Thank you, that's got me straightened out. Much appreciated.

Obliged, Steve, thanks.

Now I've got a somewhat different issue, but I can see the echoes (and grab the .exitcode!).

However, when I run this .bat via cmd.exe, it returns what I...

Glad to hear you're good to go auto.

Thanks for the cover J Livingston. Can't believe I forgot to put in the extra security wrapper... d'oh! :hehe:

As promised, Auto, I'm back. Bit later than I'd hoped, but as usual I'm on the run again. Glad to see you were able to research my recommendation....

Auto,

While Eirikur's solution will work, there's a massive triangle join in the middle around that outer apply, unless I misread it (possible, I'm doped on Nyquil at the moment). ...

Pharmkittie: Good luck! Situations like that are another side of why I'd written the article, for anyone who just didn't understand what our jobs really looked like. I'm...

Thanks for the kind words. I'm glad folks are still getting use from this article.

Change the internals of the data targets to only have a single column instead of just the copy/paste of the body. When I'm forced to do that I usually...

the connection to the third tier is AND, not OR, and thus both T1B and T1C are needing to run.

Change that to an OR and that should clean up that...

Thanks for the question Andy. Particularly like the setup.

I, personally, just dragged my lunch back into the office so Junior could stop freaking out and read me the blinking...

TomThomson (3/11/2014)

---

Koen Verbeeck (3/5/2014)

---

Interesting question, but I do not agree entirely with the answer.

Setting the commit size to a lower value will commit batches before the entire load is done....