maybe preprod is actually consuming that 70% of memory the app pool wants but dev isn't? I would be quite leery of setting a MIN memory so high personally.

If...

Someone (Argenis Fernandez??) recently had issues with memory grants and checkdb. My recollection is that they REDUCED the memory available for checkdb to make it run WAY faster and...

1) SP1 has a CRITICAL BUG that has a MANDATORY patch for it. You MUST at least apply that.

2) SP1 has MULTIPLE (IIRC) memory leaks that will suck away...

Assuming the query can complete, run it with show actual execution plan enabled. Then start looking for a) huge disparities between estimated and actual rows and b) sort/hash spills...

There are indeed memory leaks in SQL 2012 SP1+. I don't know that your dev box would be open to them tho.

Did you set the max memory for SQL...

I just LOVE Paul's posts!!

Are you REALLY REALLY REALLY sure the code is the same on both servers?!?! :Whistling:

I was just looking for some simple action on the column, like a mod or...

I don't have (unpaid 😎 ) time to give it a go, but I would look to unwind that logic into the SELECT statement if possible.

Also, to validate...

In addition to what others have said another ramification of what you seek (pun intended!!) to do will also prevent the optimizer from getting good estimates on rows to be...

Looks like you need to test for the number of parameters that are NOT NULL and then redistribute the values based on that number (either 3 or 4 of them...

1) Yep - that's a scalar UDF alright 😀

2) At least it doesn't have ancillary data access!

3) Looks like some kind of funky iterative logic that might be able to...

shahgols (11/8/2013)

---

I really appreciate your response and patience!

If I run Profiler, the sql statement will never finish. haha

I am using sp_whoisacitve. the CPU usage is much, muuuuch higher...

shahgols (11/8/2013)

---

Hi everyone and many thanks for your responses.

I had already checked on differences between table schemas, indexes, data, and also on wait/locks/etc. but didn't find any differences. I...

shindle 17293 (11/7/2013)

---

I have a 64 million record table that I need to create temporary backups of.

I am cutrently using the SELECT INTO... FROM... method but this doesn't create the...

I am not at all convinced this is a plan thing. I would be more interested in waits on the production server. latching, locking, IO, CPU, etc.