October 2009 - Posts

• Simple Fibonacci calculation

  I have listened to the critique in the comments and removed the advanced version where you can calculate virtually any Fibonacci number. Contact me if you have the need for it again. I won't bother non-interested people with the algorithm here. Instead, Read More... Posted Sunday, October 18, 2009 3:08 PM by Peso | 10 Comments Filed under: Algorithm, Math, Optimization

• Performance consideration when using a Table Variable

  This is nothing new to me (I come across this autumn 2007) and probably not to you either but I forgot about it and yesterday it came alive again. I often choose a table variable for performance reasons (if data is less than 1 page anyway) due to the Read More... Posted Thursday, October 15, 2009 4:26 PM by Peso | 5 Comments Filed under: Optimization

• New baby DBA

  Today our son was born. A healthy baby of 4.4 kg (9.8 lbs) and 53 cm (20.9 inches). Both mother and son are well, and spend the night at the safety on the hospital. Water broke 2:45 am this morning and we were admitted to the ward at 4:21. Our son was Read More... Posted Sunday, October 04, 2009 7:16 PM by Peso | 10 Comments Filed under: Miscellaneous