Last time we created a simple, but not particularly useful, stored function. This time, we’ll create something a little more complicated and useful. (more…)

The knee-jerk reaction to poor query performance is ‘Create an index!’, but this is not always guaranteed to improve query performance, and in some cases can even damage it. (more…)