Viewing 15 posts - 1 through 15 (of 35 total)
Goldie Lesser (12/5/2008)
Noel, that article is AMAZING. Here's the part that makes the biggest difference:
Not all search routines...
Tim Januario
January 7, 2013 at 3:39 pm
@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). ...
Tim Januario
March 1, 2011 at 12:28 pm
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....
Tim Januario
March 1, 2011 at 12:18 pm
Seriously? No replies? I even have sample code...
-tim
Tim Januario
March 1, 2011 at 8:08 am
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...
Tim Januario
August 13, 2010 at 9:28 am
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...
Tim Januario
July 6, 2010 at 5:37 am
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....
Tim Januario
April 14, 2010 at 3:42 pm
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...
Tim Januario
March 29, 2010 at 2:42 pm
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.
Tim Januario
March 16, 2010 at 10:49 am
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...
Tim Januario
March 16, 2010 at 9:54 am
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...
Tim Januario
March 16, 2010 at 8:21 am
Removed
Tim Januario
February 19, 2010 at 11:40 am
Like building sand castles at high tide...
Tim Januario
February 19, 2010 at 11:36 am
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...
Tim Januario
February 19, 2010 at 11:29 am
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,...
Tim Januario
February 19, 2010 at 11:17 am
Viewing 15 posts - 1 through 15 (of 35 total)