|
Well for me at least.
I have a similar stored procedure ... well actually it is broken up into 5 parts, each more daunting than the rest. But, ..., the EPA changes its mind a lot and bases forward rules on past and forward conditions so, well, it is slow, slow mess.
For a lark, I loaded the entire DB into ram and processed the data for about 5 years with code and dictionaries and achieved the same result which previously took hours in seconds.
As such, I really advocate SQL Server as a dumb vessel. (heck, I have a partitioned view right now that still doesn't work right, SQL Server continuously refuses to use the partitions constraints (which are valid btw))
|
|
|
|
|
no doubt memory search will be way faster!!! 
|
|
|
|
|
I would like to store my freelance and hobby projects in web repository.
At the moment I have no intention in sharing them.
Can you recommend me a good service or solution?
Bitbucket[^] and Assembla [^] have caught my eye, but affordable web hosting solution with repository would be nicer as I'm in the process of changing my hosting provider  .
Mislim, dakle jeo sam.
|
|
|
|
|
Why not just host your own? There are plenty of good tools out there to do so.
"I've seen more information on a frickin' sticky note!" - Dave Kreskowiak
|
|
|
|
|
I have a hosting account with 1&1 and they provide online storage with hosting accounts.
|
|
|
|
|
I use CloudForge[^] - free SVN or Git & their own TeamForge product
Quote: CollabNet TeamForge integrates software configuration management (SCM), continuous build and test, issue tracking, project management, lab management, and collaboration tools into a single Web-based application lifecyle management platform that empowers distributed teams to deliver great software.
which I haven't used yet but looks quite nice.
|
|
|
|
|
This looks promising.
Mislim, dakle jeo sam.
|
|
|
|
|
|
|
Mike Hankey wrote: Ah the fond horrid memories!
FTFY
|
|
|
|
|
Thought of VMS for the first time in years a couple of days back...
Ger
|
|
|
|
|
Ger Hayden wrote: Thought of VMS for the first time in years a couple of days back...
Did you have nightmares? I do when I think of VMS! 
The report of my death was an exaggeration - Mark Twain
Simply Elegant Designs JimmyRopes Designs
I'm on-line therefore I am.
JimmyRopes
|
|
|
|
|
No - They come when I think of BULL-GCOS6...
Ger
|
|
|
|
|
"unix is free (and worth every cent)...." 
|
|
|
|
|
|
All those ad wards... is that where sick ads go?
|
|
|
|
|
_Damian S_ wrote: All those ad wards
What is ad wards? 
|
|
|
|
|
It's in a big building full of sick people.
Or your subject, one or the other.
Perhaps you should get an award for your adward?
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: Perhaps you should get an award for your adward?
Now I will have to leave it like that.
|
|
|
|
|
I love the comments and laughter from the guys recording it
But why would he be dancing right there?
Soren Madsen
"When you don't know what you're doing it's best to do it quickly" - Jase #DuckDynasty
|
|
|
|
|
SoMad wrote: I love the comments and laughter from the guys recording it
Me too. They thought it was funny.
SoMad wrote: But why would he be dancing right there?
Drunk or otherwise impaired I would suspect. 
|
|
|
|
|
You should have known this actually happened.
|
|
|
|
|
I choose to believe your link is the fake video 
Soren Madsen
"When you don't know what you're doing it's best to do it quickly" - Jase #DuckDynasty
|
|
|
|
|
Yep, fake! Even I could tell it by pixels
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
