11 reputation
2
bio website
location
age
visits member for 1 year, 6 months
seen Aug 9 '13 at 20:42

Aug
7
comment fighting filter (nested loops) execution plan from Oracle
I see what @sehrope is saying. And since the sub-queries aren't requesting a distinct list of 'val' from small_table it could be "reasonable" (even if not absolute) to assume that the value isn't duplicated.
Aug
6
answered fighting filter (nested loops) execution plan from Oracle
Dec
2
awarded  Teacher
Oct
7
comment Why does the query cost change so much and how to prevent it
@ChrisSaxon, If I could I'd +1 your answer I would. That's a great explanation of what's going on. I didn't really think of it that way. Thanks.
Oct
5
comment Why does the query cost change so much and how to prevent it
@ChrisSaxon, while I can appreciate that the best option is to fix the query, sometimes time doesn't allow us the luxury while our users suffer through poor performing DML. We must remain open to the options available to us. CBO is prone to problems in situations such as this...ignoring RBO when it's still available to us is a mistake. If it gets the query performing better in the short term then we have the luxury to take our time testing fixes.
Oct
3
comment Why does the query cost change so much and how to prevent it
I found another post that suggested it's better to use "where exists" instead of "where <field> in". I can't say I've tried that before, though I've seen it used once or twice.
Oct
3
answered Why does the query cost change so much and how to prevent it
Oct
3
comment Cannot start SQL SERVER SERVICE in Windows Server 2000
I can only add comments to my own answers (probably because my rep is too low since I'm a noob here) but I would think you can find a bit more info in the Dump file generated when the service crashed. That would be located in your sql server's log directory. It might tell you what it was attempting to access when it died.
Oct
2
awarded  Editor
Oct
2
revised Cannot start SQL SERVER SERVICE in Windows Server 2000
Following Max's suggestion and providing further detail
Oct
2
answered Cannot start SQL SERVER SERVICE in Windows Server 2000