Goldie Lesser (12/5/2008)

---

Thanks to both of you for those references. They were both extremely helpful.

Noel, that article is AMAZING. Here's the part that makes the biggest difference:

Not all search routines...

@opc.three

Actually, you helped me find the answer. The big difference, right at the top, was the use of parameters in my execution plan (which my query doesn't use). ...

You are getting a very different query plan than I. I noticed that your build is R2 (10.50.1765.0), we are running 10.0.4000.0 which could potentially account for the difference....

Seriously? No replies? I even have sample code...

-tim

I was having this problem as well on a sql2008 box. From the local server (where the linked server is defined), I executed SELECT * FROM master..sysservers and noticed...

Hello Henners,

I was also unaware until recently, and am not sure how much it is used by the optimizer (the only thing I can think of that this would allow...

I'm not sure if that's quite what I'm looking for, though. I'm looking for a way to partition the data based on where a row sits in a hierarchy....

One of the events that you can track is the Errors and Warnings:Blocked Process Report in sql profiler.

By default this event won't be thrown because it's actually a report that...

I think I'll suggest we go the cost threshold route rather than just killing the entire thing. I appreciate everyone's input. Thanks Grant especially for yours.

Is there a sound way of determining what the threshold should be? I have no idea what it would mean to the planner, for example, to double the default...

But the issue as I see it isn't necessarily that parallelism is happening, but that when it does, it actually performs worse. Most of the time that I see...

Removed

Like building sand castles at high tide...

Thanks Roy (I mean Lynn, I mean Cirque)!! :angry: I -WAS- done until you posted. Then I felt the immediate doom of unfinished business take hold and...

Yes!!! I am post 11,869 on a single thread. I went all the way to the beginning and read every single one. BTW - very funny Mr. Smith,...