There are many variables at play when it comes to dealing with performance issues. You mentioned the configuration of your production system: 32 GB RAM, 16 cores (how many...

In fact, you may want to compare the actual execution plans between the various servers and see what is different.

And your servers are not identical. We need to see the actual execution plan of the query on the production server plus the table structures and indexes.

Please read the second article I reference below in my signature block regarding asking for help on performance issues. You really haven't provided all the information we need to...

And the article Luis recommended will help you understand the code I posted.

Since you did not provide anything from which to really work (DDL or sample data), this is the best I can do for you. Not sure if it will...

Thanks!

I...

I have been home since Sunday afternoon and today is the first day it has been warmer than it has been at night back in Afghanistan.

Jeff Moden (1/27/2014)

---

Shifting gears a bit, in the last 20 interviews that I've conducted, I ask the candidates to wirte code to create and populate a table with all integer...

Sean Lange (1/27/2014)

---

No the query that Lynn posted has nothing to do with when the value was created....

Jeff Moden (1/26/2014)

---

squeekz01 (1/26/2014)

---

Hi guys,

I am looking for help with writing what some may find as a basic query... I need to be able to scan all tables in my...

Jeff Moden (1/27/2014)

---

The reason why I'm the one doing the interviews is because these particular companies don't just want "butts in seats". They actually want people that know what...

Jeff Moden (1/27/2014)

---

Lynn Pettis (1/26/2014)

---

Jeff Moden (1/26/2014)

---

Since it was appropriately...

Jeff Moden (1/26/2014)

---

Since it was appropriately brought up, I have...

Thanks to all who answered my question so far. I was just curious as I overheard one of our SAs make the comment that it was a best practice...