|
John Simmons / outlaw programmer wrote: I encountered a view that has 519 OR clauses that evaluate the value of 20 columns. When run in its original form, it took 11 seconds to execute and returns 2900 rows. I modified it to declare a varchar variable and then called CHARINDEX for each column one time, and execution time is now < 1 second.
Congratulations - you've just ensured that SQL won't be able to use an index on any those columns to process your query! 
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I'm not sure if that's a "Bad Thing" (TM) given the improvment thus far.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
Regardless of the improvement seen, is the solution offered the best solution available?
Bear in mind, somewhere down the road, someone will look at the solution offered, decide is was the best option, and use it again (possibly in an area where it doesn't make sense to do so).
|
|
|
|
|
Perhaps not a bad thing per se; but it does suggest that there is room for farther improvement as time permits.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius
Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies.
-- Sarah Hoyt
|
|
|
|
|
|
Have you already discovered you need a new DBA? 
As for 0, but I believe you already know that, you can't 'trick' SQL into ordering your views.
When you use a TOP(X) PERCENT SQL needs to know what it need to get the TOP of. The only way to make sure you always get the same records (given none are deleted or inserted) is by ordering the query.
Within the TOP(X) rows order isn't guaranteed. In practice it will be ordered about 100% of the time though (unless you do a TOP(100) PERCENT, because SQL will know that's everything so it won't have to order  ).
It's an OO world.
public class SanderRossel : Lazy<Person>
{
public void DoWork()
{
throw new NotSupportedException();
}
}
|
|
|
|
|
|
The tat on that page doesn't make the mutt attractive: but it does distract from it's ugly mug, which may be the idea...
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
Terrible law...
I was going to tattoo the names of each of my goldfish on their sides so I could keep track of them all in my aquarium. Now how will I tell who is who?
|
|
|
|
|
Easy! an aquarium for each fish...
entia non sunt multiplicanda praeter necessitatem
|
|
|
|
|
That would be cruel! They are the siamese fighting fishes[^] and they are so fond of each other 
--
"My software never has bugs. It just develops random features."
|
|
|
|
|
staple a nametag to each one
You cant outrun the world, but there is no harm in getting a head start
Real stupidity beats artificial intelligence every time.
|
|
|
|
|
Have you considered color coding with permanent markers?
|
|
|
|
|
First thought: This doesn't need to be a law. This should be common sense.
Second thought: There are chihuahuas in pink sweaters and socks in my neighborhood. If they're going to humiliate the dog that much, the tattoo isn't far off. New Yorkers are crazy... I would know. I'm one of them*.
* But I'm a completely different kind of crazy...
|
|
|
|
|
Ian Shlasko wrote: There are chihuahuas in pink sweaters and socks in my neighborhood.
There ought to be a law against that. 
Once you lose your pride the rest is easy.
I would agree with you but then we both would be wrong.
The report of my death was an exaggeration - Mark Twain
Simply Elegant Designs JimmyRopes Designs
I'm on-line therefore I am.
JimmyRopes
|
|
|
|
|
In the summer time, yes. When it's really cold, who cares what color? Keep your doggies warm!
|
|
|
|
|
Chihuahuas aren't dogs; they're rodents.
You'll never get very far if all you do is follow instructions.
|
|
|
|
|
"If I can drop-kick it over my back fence, it's not a dog."
-- Jeff Dunham
|
|
|
|
|
And so are those hairless objects, like the Chinese Crested[^]
And where is the point in a Sphynx cat[^]?
Don't get me wrong, I like dogs; I like cats. But those? No. Just "No".
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
OriginalGriff wrote: Sphynx cat
Nothing wrong with a hairless pu.. [CARRIER LOST]
You'll never get very far if all you do is follow instructions.
|
|
|
|
|
Even other dogs don't think Chihuahuas are dogs! 
Once you lose your pride the rest is easy.
I would agree with you but then we both would be wrong.
The report of my death was an exaggeration - Mark Twain
Simply Elegant Designs JimmyRopes Designs
I'm on-line therefore I am.
JimmyRopes
|
|
|
|
|
But how else will people know what the names of my dogs nineteen pups are, unless I tattoo them across his chest?
Also how will Japanese people be able to tell his name?
|
|
|
|
|
For dog meat only the Veterinary Meat Inspection Stamp, the tatoo of first name isn't required!
entia non sunt multiplicanda praeter necessitatem
|
|
|
|
|
Hi All,
Had a bit of a pointless week (what I though would break, didn't & the update to something I have ready to send when it asked for, hasn't been asked for), the question I have today has the Darlek escaped Man-Eisly (Manchester) with his limbs (or tires) attached....
|
|
|
|
|
The tires are attached. Just not necessarily to HIS car.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
