Please post the actual execution plans for both calls.

chuck.forbes (2/3/2016)

---

We have several different versions of SSIS, installed mostly long ago on servers alongside a particular db version (MSSQL 2005, 2008, 2012 and 2014). So for SSIS changes, we've...

Sergiy (2/3/2016)

---

Ed Wagner (2/1/2016)

---

If you implement this is a trigger, which is what it looks like, you'll also want to make sure the trigger performs well enough that if you...

removed silly post...

mister.magoo (2/3/2016)

---

Orlando Colamatteo (2/3/2016)

---

By the very nature of how a compiled application's deployment model works the developer or admin is compelled to go to a VCS where the plain-text class...

Eric M Russell (2/3/2016)

---

Orlando Colamatteo (2/3/2016)

---

Eric M Russell (2/3/2016)

---

Let's assume that the business requests a high priority modification to functionality currently in production. Let's also assume that the development team...

Eric M Russell (2/3/2016)

---

Let's assume that the business requests a high priority modification to functionality currently in production. Let's also assume that the development team has recently made an unrelated...

Andy Warren (2/3/2016)

---

Orlando, it's far from comical, though it does often have to do with trust and fear. We're the guardians. Sometimes we take that role too far, sometimes not...

xsevensinzx (2/3/2016)

---

When I create an object, it should be submitted, reviewed, tested and then pushed onto production. Any changes that avoid this process is like playing with fire. You either...

JustMarie (2/3/2016)

---

I still got truncation using the output to NVARCHAR. I'm surprised that your testing didn't show the same thing unless you didn't butt up against the limit.

Since I...

SQL_Surfer (2/2/2016)

---

I've about 200 SSIS packages that needs to be run on 10 different instances. What is the best way to configure this dynamically? Ideally I'd like to store them...

If you choose to use resultsets, yes, that...

It is a strength and a...

Thanks for posting back. This is a great topic. Thanks for raising it Steve. I am hoping there are a bunch of folks enjoying their popcorn watching this one because...

Eric M Russell (2/2/2016)

---

From the perspective of a DBA, I'm sure most of us would prefer that stored procedures an views be stored in clear text and that we have...