SQL behind Business Intelligence
I found something funny with the Oracle Keep / { First – Last } analytic function, on 11.0.0.6 & 11.0.0.7.
Same thing occurs also on Oracle 10g XE.
For those who don’t have a clue about this function, I wrote a small post on this subject.
This afternoon, I was chatting with Antoine Gémis about T-SQL, and this subject came on the table.
He was asking if, in my opinion, using both a distinct and an order by in the same statement would make the query worst due to the fact that distinct is already performing a sort on his own.
Working mostly with Oracle, and being sure distinct is not doing any sort, this was my first answer : “As far as I know, distinct is not performing any sort”.
Continue reading ‘Is Distinct A Synonym To Order By In MS SQL Server ?’
Since I’ve upgraded this weblog to WordPress 2.8, I’ve been involved into opening the php files of this RGB theme to make some tweaks.
After 2.8, my sidebar was frozen. As it is an essential part of the theme, I decided to look for another one, which I did fairly quickly with greyville.
Even if I was missing the colorset, I was really enjoyed by the readability of the new theme and some options in the sidebar.
In the same time, Ozh was fixing the RGB sidebar issue.
Damn, I’m currently pushing a small SQL Server application database to an Oracle datawarehouse.
There are guids everywhere, even for a two rows reference table.
This is just so unreadeable and unconfortable to work with.
Try co-working on that kind of database, where you have to dig into the datas to understand them, the design flaws, the weird things and stuff.
Continue reading ‘I Dislike Guid As Primary Keys’
This is the query I sent to the TC team. I published it when I sent it, but they prefer to keep solution secret as long as the closure date isn’t in the past, which I can understand.
I had fun using PIVOT and UNPIVOT operators to reduce the query size.
PIVOT / UNPIVOT syntax isn’t part of ANSI SQL but is supported in both SQL Server 2005+ and Oracle 11g.
First, I’ve got to assign an unique identifier to the rows of the table. Continue reading ‘My TSQL Challenge 10 Pivot-UnPivot Solution’