Categories
Programming

SQL Server: Find Expensive Queries by Running One

I have found that Activity Monitor can have a habit of bugging out on you when you try to get recent expensive queries. If you also get this, you may want to try the following query instead. You can adjust the query purposefully by changing the ordering, based on what you are looking for. There […]

Categories
Process

Faster Faster Faster

I was listening to someone talking about being agile and lean in software development. The conversation was very interesting, but there was an underlying theme of urgency and efficiency that I found troubling. There is nothing wrong with delivering quickly, but we should never forget that “you can only go fast if you go right” […]

Categories
Programming

Query Optimisation Is Still Alive

When I was working on SQL 2000 databases back in the day, the ordering of your joins and where clauses could make an insane difference to query performance. I was working on a reconciliation system that grew by a million records a month – so a simple re-order of a where clause would blast a […]

Categories
Programming

Speed Up Dynamic Websites with Static Pages

I have stuck with my trusty content management system for years, but the weight of content combined with the number of visitors has been causing page speeds to suffer a little recently. Average page load times have been landing in the 3 to 4 second mark, which sucks. So a tactical change was required to […]