The Lounge is rated PG. If you're about to post something you wouldn't want your
kid sister to read then don't post it. No flame wars, no abusive conduct, no programming
questions and please don't post ads.
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))
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 .
I use CloudForge[^] - free SVN or Git & their own TeamForge product
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.