Data, Process, Insights & things I write about
What is this about? # In his blog post Why are scalar UDFs so slow? Jörg Brandeis wonders why user defined scalar functions (scalar UDFs) are slow compared to plain SQL. This is an important question since UDFs would… Read More » Why are your scalar UDFs slow? (mine aren't)
In Matchmaker, I developed a solution to a not-so-obvious problem. The solution worked and delivered the right answer - finding documents where the line items match to a certain degree the line items of a reference… Read More » Matchmaker - quick quick?
SQL is an easy language to learn. A few commands to learn ( SELECT/FROM/WHERE/GROUP BY) and you are good to go. One downside of the simple syntax and small vocabulary is that it can lead many SQL users to the assumption… Read More » Matchmaker
Q&A forums can be a treasure trove of interesting questions that turn out to have counter-intuitive answers. In “Why does select statement taking too long when primary key is present?” the OP made an interesting… Read More » One in a Million