SQL behind Business Intelligence
NoCOUG Challenge
After many months, Iggy Fernandez published his own solution of the first annual NoCOUG SQL Challenge.
His solution was performing fast from the beginning according to the graph he sent to Chen Shapira back in the announcement days :
I never managed
Well, this was a long wait for every participant of this challenge.
I entry the contest in April, and the winner has been announced yesterday by Iggy Fernandez and Chen Shapira.
It was indeed an amazing challenge and I thanks everyone who brought this up.
It was also the key factor for me to open this blog to [...]
NoCOUG
Well, I’m not really comparing comparable numbers here.
The NoCOUG last submit date was the last day of june, and therefore it is past.
Iggy Fernandez wrote about the nine different solutions he received (I very like the title he has chosen) !
I’m the seventh in the list there.
As I told before, my favorite solution to this [...]
TSQL Challenge
Last month I answered about a SQL Challenge from Antoine Gemis (french here). My solution wasn’t very nice, I used a flaw in the data to provide an easy query with basic outer joining.
As the only challenger, I won it !
Antoine’s told be about some regular TSQL Challenges (meaning SQL Server) but i didn’t [...]
Trying to improve the cross join part by faking it.
Results shows Oracle gains twice while MS SQL Server loose twice.