Viewing 15 posts - 2,311 through 2,325 (of 5,841 total)
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...
November 13, 2013 at 6:26 am
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...
November 13, 2013 at 6:25 am
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...
November 13, 2013 at 6:23 am
I just LOVE Paul's posts!!
November 12, 2013 at 6:00 pm
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...
November 12, 2013 at 2:38 pm
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...
November 12, 2013 at 12:36 pm
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...
November 12, 2013 at 12:30 pm
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...
November 12, 2013 at 10:29 am
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...
November 12, 2013 at 10:19 am
shahgols (11/8/2013)
If I run Profiler, the sql statement will never finish. haha
I am using sp_whoisacitve. the CPU usage is much, muuuuch higher...
November 9, 2013 at 9:31 am
shahgols (11/8/2013)
I had already checked on differences between table schemas, indexes, data, and also on wait/locks/etc. but didn't find any differences. I...
November 8, 2013 at 3:50 pm
shindle 17293 (11/7/2013)
I am cutrently using the SELECT INTO... FROM... method but this doesn't create the...
November 8, 2013 at 7:04 am
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.
November 7, 2013 at 7:17 pm
shahgols (11/7/2013)
I have a query that calls on a UDF. In staging, has the same number of records and schema, it runs in 25 seconds. On...
November 7, 2013 at 4:09 pm
eyespi20 (11/6/2013)
SELECT node_id, node_state_desc, memory_node_id, online_scheduler_count,active_worker_count, avg_load_balance
FROM sys.dm_os_nodes WITH (NOLOCK)
WHERE node_state_desc <> N'ONLINE DAC' OPTION (RECOMPILE);
What information does this give...
November 6, 2013 at 10:28 am
Viewing 15 posts - 2,311 through 2,325 (of 5,841 total)