Source: mcol_histogram.sql
When running an OLTP system you may have a transactions table with things like transaction ids, transaction types and states of transaction (open, closed, cancelled, etc). Different transactions tend to have different usage patterns – some might be automatically dealt with, others require user interaction, some typically rejected and still others where a [...]
Source: trigger.sql
If you are in a mutating table situation where your trigger needs to read from the same table that it is firing on your only real option before Oracle 11g was a multi trigger solution with a muddle of row and statement triggers communicating via a package. But now Oracle 11g comes through [...]
I recently needed to convert a large file from UTF-8 to Unicode. While Notepad actually does a pretty good job of this I wanted it to fit within an automated build script. After looking around on the web for a while the only thing I found took several minutes to convert a 6MB [...]
Source: ParallelComparison.zip (8kb)
After completing the STDEV test on Javascript I wondered how fast I could get the C# version to go using some of the new parallel extensions in C# on my dual core non-HT E4500 (so only two threads). Of course the first problem is that the Parallel Extensions CTP has been taken [...]
After my previous post which was a Shootout between SQL Server, Matlab and C# on Standard Deviation (STDEV) I thought I might try doing it in Javascript to see how it performed on speed and accuracy. I needed to make an ADODB connection to the database using ActiveX on OBDC through a System DSN and [...]
Let’s say we have an mathematically intensive application written in C# with SQL Server as the backing database. When designing the application it can be convenient to call on the wealth of libraries and rather convenient IDE in a product such as Matlab. My normal thinking would be to first design and test [...]
Install: Transperth Live Train Times Extension (8kb)Source: ArbitraryWebSlice2.zip
After finding how simple it was to build the Arbitrary Web Slice Chrome Extension for the BOM website I decided to try another site. This time I wanted to get the TransPerth live train times because the full site is slow to load, the refresh reloads the [...]
To see how Chrome Extensions work I revisited my Arbitrary Web Slices post. A great starting point was Google’s own Hello World extension. Indeed all I really needed to do was start with that, cut and paste code from my other post, add some icons and it was done.
Let’s start with the barely edited (from [...]
Following on from my earlier post on AJAX Push – Comet I decided to add some pure javascript graphing, a little logging to disk, some robustness to handle dropped connections, some pull AJAX to get the prices which don’t seem to stream (JPY) and some pretty tooltips.
This is the result of those changes:
The dynamic colouring [...]
I had hoped to come up with a neater version of my Weekly Transaction report using the new PIVOT function in Oracle 11g but I wasn’t able to come up with anything much better primarily due to:
ORA-56901: non-constant expression is not allowed for pivot|unpivot values
So let’s take a look at the revised version of the [...]