Monthly Archives: June 2014

So this is a cheat, this isn’t my blog post at all, but a colleague recently pointed me towards a talk Rob Farley gave on Designing for Simplification and it was just too good to not blog about. I have yet to watch the whole video and I am yet to be completely sold on the … Continue reading →

Query tuning is a lot of fun. At times it can be challenging and frustrating but ultimately getting good performance gains is immensely satisfying. I have been doing a fair bit of this at work recently, and one of the challenges I have been facing is to quantify the improvements. Total running time is simple … Continue reading →

This afternoon I got a call from a client with a problem with their replication setup: transactions were not being replicated across to the subscriber. Below is a record of the steps I went through to investigate this issue. Step 1: Review Replication Monitor This is always my first point-of-call. I fired up the … Continue reading →