SQL behind Business Intelligence
That title is sounding odd I admit it.
In the french forums développez.net there is a regular mistake that I try to emphasize on each time I read it, it's the use of GROUP BY without any aggregate functions to perform a regular DISTINCT operation.
Here's a very simple example (if you're not working on Oracle just [...]
TSQL Challenge #13
My previous post was a very long one and it took me several hours just to write it properly, plus many hours to do the findings (which was a part of my day job, but most of the tests were done at home).
Having zero comment is a little frustrating to be honest, I [...]
The Discovery
I have been working the last couple of months around some data matching, string of course, and I started this one as a full beginner on the subject.
Well, I knew the very basics : equal strings match with the equal operator (I bet you knew this one too), nearly equal strings can also match [...]
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 [...]