Could be a server setting, but most likely it is because of different statistics.  Update stats on the dev server and see what happens.

If you post the plans...

My recommendation is always to have the application handle encryption and decryption.  If you use encryption builtin to SQL Server it makes it easier for people with access to the...

Have you run a trace/XE session on the SQL Server to ensure that the query performance when called from SSRS is still as fast as SSMS?  If you've never read...

Ha ha.  I clicked on Latest Posts and this showed up and it is 16 years old and I replied.

I think all you need is to add cs-username to the SELECT and add a GROUP BY cs-username.  Like this:

SELECT
  [cs-username],
  SUM(CASE WHEN...

I have dealt with this in the past.  If you use the transaction handling in SSIS as you have tried, it requires that DTC be running and configured correctly.  The...

My rule of thumb for creating a constraint vs an index is the purpose of the object.  If the main purpose is to enforce a business key (uniqueness) I create...

Hey, long-time no hear from.

Any chance you could normalize the structure so the Yes/No columns are in a separate or separate table(s). Maybe even an EAV table,...

Gary Varga (12/5/2016)

---

Some people copyright their articles/blog posts but explicitly specify that the code is free to use. This is a reasonable case where the author is trying to educate...

Steve Jones - SSC Editor (11/22/2016)

---

Have to drop this here, since I'm proud.

My son completed his Board of Review last night to earn his Eagle Scout rank. It's been a...

jasona.work (11/2/2016)

---

Luis Cazares (11/2/2016)

---

I'm not looking for a job, but I take a look at offers from LinkedIn every now and then just to see what's being offered/requested.

That said, can...

Hugo Kornelis (11/2/2016)

---

Jack Corbett (11/2/2016)

---

and that one of the queries re-used the plan from the other one (RetrievedFromCache is true in one case). At least I'm making...

Grant Fritchey (11/2/2016)

---

I'd like to request a beating from the Threadizens.

I have a blog post[/url] that I'm informed doesn't adequately test the question I'm attempting to answer. You guys will...