Viewing 11 posts - 1 through 11 (of 11 total)
Yet Another DBA (4/14/2014)
Vlad-207446 (4/14/2014)
Hell, I personally know several DBAs (one is my friend and the other person I know through the mutual firend) whos company made a desicion to...
April 14, 2014 at 7:22 pm
Optimizer hints is a very powerful tool and it is extremely easy to shoot yourself in a foot with. One should intimately know the data and SS before attempting to...
August 3, 2011 at 8:23 am
Sorry for my impulsive reply. I just finished handled a performance issue caused by "it knows better" attitude. No attack perceived or meant
August 2, 2011 at 1:39 pm
Ninja's_RGR'us (8/2/2011)
No offense but the ms engineer working on this are, how can I say this, NOT MORONS.
I...
August 2, 2011 at 1:23 pm
It is true in the case of “a horse as a point in the absolute vacuum”. In the real world optimizer sometimes chooses very suboptimal plan, due to timeouts or...
July 25, 2011 at 8:40 am
Why not just use optimizer hint to force the plan that performs better?
July 22, 2011 at 7:56 am
Paul White NZ (4/3/2010)
1. This table probably does not benefit from having a clustered index. If...
April 4, 2010 at 5:33 am
Sorry, I missed it.
Then just, "what is exact query that performs poorly?"
April 2, 2010 at 9:11 am
Will converting varchar(8) to char(8) help? What is average length of the code values?
What is exact scenario that exhibits poor performance on that table?
April 2, 2010 at 8:26 am
Viewing 11 posts - 1 through 11 (of 11 total)