|
Chris Maunder wrote: SQL Server is terrible at making guesses sometimes.
O yes, I know. Thats why you have to split the sp's sometimes. The main sp can still exist, so you doe not have to change other code, but if you let that sp call different sp's, you help SQL to choose its indexes. It is sometimes more simple than working with idex hints.
Wout Louwers
|
|
|
|
|
We think we've solved the proble,. The trick: removing an index. SQL Server can suffer a problem whereby it doesn't have time to evaluate the indexes properly so chooses the wrong one.
cheers,
Chris Maunder
The Code Project | Co-founder
Microsoft C++ MVP
|
|
|
|
|
Never knew a select query could benefit from removing an index. So I allready learned somthing new today. And my workday has just started!
Wout Louwers
|
|
|
|
|
|
You could try a Who's Who filter of cheap* and be surprised at the outcome.
These guys know their HTML.
Not sure it is safe!
|
|
|
|
|
Good gravey!
Thanks,
Sean Ewington
The Code Project
|
|
|
|
|
I've just tried to delete a reply from the spammer below, and got the following response:
"Error: Exception of type 'System.OutOfMemoryException' was thrown.. Ticket: 2227260. Server: Web17"
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
Hmm - interesting.
Web17 has always been a trouble maker and I actually pulled it out of the cluster last night on my way to decommissioning it completely.
Someone left the door open and he snuck back in.
cheers,
Chris Maunder
The Code Project | Co-founder
Microsoft C++ MVP
|
|
|
|
|
servers normally want to get out, not in. You shouldn't trust that one any longer! Please revoke all of its privileges.
|
|
|
|
|
This Member[^]
Only posted to spam on Q&A
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
|
|
|
|
|
|
|
And many more:
Check this post[^]
Currently I am editing their answers to remove the messages.
..Go Green..
|
|
|
|
|
Racking up those edit points!
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
|
|
|
|
|
..Go Green..
|
|
|
|
|
|
This[^] also needs deletion i guess.
..Go Green..
|
|
|
|
|
Thanks for helping out guys, I think you scared them off
Just in case though, we incinerated them
Thanks,
Sean Ewington
The Code Project
|
|
|
|
|
|
Thanks Tom
And a BIG thanks to Dave! That must have been a lot of work. You guys are amazing. We should have a new Icon / Status - Code Project Soldiers
Thanks,
Sean Ewington
The Code Project
|
|
|
|
|
|
|
http://www.codeproject.com/Redir.aspx?adid=14251&adcrid=12393&obid=1&obtid=4&way=ban
Error: Object reference not set to an instance of an object.. Ticket: 2225801. Server: Web18
|
|
|
|
|
All fixed. Thanks!
cheers,
Chris Maunder
The Code Project | Co-founder
Microsoft C++ MVP
|
|
|
|
|
I don't see why this was downvoted. Let me fix that for you.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|