Brandie Tarvin (10/18/2016)

---

If I am reading this correctly, you aren't even executing the procs in the same manner in the SSIS...

river1 (10/17/2016)

---

Hello, Thank you for the feedback. Both on same machine. The ssis package performed much better then the script. With the package I take 16 minutes. With the script...

What a morning. SSC just broke my heart.

I see an article about time traveling listed in the newsletter. Get ready to read it and realize, it's not talking about building...

No. But I'll give it a shot. Last time I saw behavior like this, it was because SSIS was running on an app server...

Are you actually executing SSIS on the same exact machine / instance in SSIS as you are executing the procs in SSMS?

And, if so, how are you executing SSIS?

Which is...

Ed Wagner (10/17/2016)

---

Phil Parkin (10/17/2016)

---

Brandie Tarvin (10/17/2016)

---

rodjkidd (10/17/2016)

---

So hands up who loves the idea of a production db being called Test_Autos on a server that was the test server...

Yes a...

rodjkidd (10/17/2016)

---

So hands up who loves the idea of a production db being called Test_Autos on a server that was the test server...

Yes a production server details were also sent...

Grant Fritchey (10/17/2016)

---

Read those when I was much younger. Which network is...

So who else is going to be watching Dirk Gently's Holistic Detective Agency when it comes out?

Sean Lange (10/13/2016)

---

Brandie Tarvin (10/13/2016)

---

ChrisM@Work (10/13/2016)

---

Brandie Tarvin (10/13/2016)

---

GilaMonster (10/13/2016)

---

Grant Fritchey (10/13/2016)

---

Sean Lange (10/13/2016)

---

WOW...http://www.sql-datatools.com/2016/05/sql-queries-tuning-and-optimization.html

This is supposed to be a list of things to do to optimize queries. While some of these...

Then you need to have...

keeyu2 (10/13/2016)

---

Has anyone able to add FCI and standalone to an AG? I am getting sql server error 19405 - If one replica is failover cluster instance, remove...

ChrisM@Work (10/13/2016)

---

Brandie Tarvin (10/13/2016)

---

GilaMonster (10/13/2016)

---

Grant Fritchey (10/13/2016)

---

Sean Lange (10/13/2016)

---

WOW...http://www.sql-datatools.com/2016/05/sql-queries-tuning-and-optimization.html

This is supposed to be a list of things to do to optimize queries. While some of these are valid most of...

Hugo Kornelis (10/13/2016)

---

Brandie Tarvin (10/13/2016)

---

GilaMonster (10/13/2016)

---

Grant Fritchey (10/13/2016)

---

Sean Lange (10/13/2016)

---

WOW...http://www.sql-datatools.com/2016/05/sql-queries-tuning-and-optimization.html

This is supposed to be a list of things to do to optimize queries. While some of these are valid most...

GilaMonster (10/13/2016)

---

Grant Fritchey (10/13/2016)

---

Sean Lange (10/13/2016)

---

WOW...http://www.sql-datatools.com/2016/05/sql-queries-tuning-and-optimization.html

This is supposed to be a list of things to do to optimize queries. While some of these are valid most of them lack context...