Ask for a redesign to merge the 2 columns. This makes no sense and will always cause you problems down the road.

Make sure that that thing that spits out our erp's data works in tip top shape, no matter what.

Too long to list all of what that entails.

Bruce W Cassidy (8/12/2011)

---

Ninja's_RGR'us (8/12/2011)

---

All you need to do is answer how can the optimzer stop at only 15 rows knowing that sorting is a blocking operator (nothing else can...

Ok, if you have 2 minutes you can see what SM has to offer (live previous of the servers hosting ssc.com)

http://monitor.red-gate.com/?utm_source=ssc&utm_medium=peel&utm_content=corner_peel201104&utm_campaign=sqlmonitor

All you need to do is answer how can the optimzer stop at only 15 rows knowing that sorting is a blocking operator (nothing else can run untill that is...

And they can't tell you what happened or what's hapenning during the issue?

Thanks for the tip!

You can get sql monitor for free for 14 days, that should give you your answer...

where a >= b

40X slower is not enough for them?

sp_update_resume, sp_distribute.

In the mean time, what changed on that server or the db sine the last successful 1 minute exec?

You use sp_startjob to start something async

See something missing between where and >??

where >= DATEADD

The only way I...

Here's how I would debug this.

Take another server, make a clean install. And then compare what's different security wise. I'm sure it's just a simple tweak or two.

Can't...

Tom.Thomson (8/12/2011)

---

Ninja's_RGR'us (8/11/2011)

---

Tom.Thomson (8/11/2011)

---

But which is crazier there - the locking hint or the tortuous where clause (getting rid...

cfradenburg (8/12/2011)

---

SanDroid (8/12/2011)

---

You are right. I should stop randomly responding when others post posts about my posts and then repost. It is annoying and it takes away attention from...