20 07 2014
Even the best written query can run away with itself sometimes; especially if you have some form of recursion in the script. Be is a while loop or a cursor; the data does not always fit the expectations of the developer. In that case the query can run and run until you run out of resources and your server starts to stutter.
19 07 2014
So perhaps the title of this post is not 100% true, more “go” than “zoom”! It has been a while since I cycled to work; last time I was knocked off by bike by a van driver and I damaged my shoulder. My shoulder has mostly healed now and my monthly parking permit has expired so I have decided to get back on my bike and cycle to work. It’s not a long way or a particularly hard route but it is enough for me (my knees don’t work very well).
7 07 2014
Today was a good day; my new shiny Samsung Gear Live smart watch arrived (plus I got stuff done at work, and I’m going to the pub shortly but that’s not the point!).
Like a good geek I took some photos as I un-boxed it from it’s rather nice fake-wood effect container. The photos are in a nice little gallery at the bottom of this post.
6 07 2014
Last week I wrote about my annoyance with O2 and Carphone Warehouse. A quick reminder being that they wanted £150 as a bond because apparently my credit rating was poor and they didn’t trust me to pay my bills!
5 07 2014
When you first take over a database system you often find that the little (but important) things have been forgotten about. There are 101 reasons why something like auto file growth can be a bad thing; the default is 10% so if you have a 10GB database you could end up seeing a 1GB autogrowth event. An event of that size is very expensive both in I/O and WAIT events.