Thinking outside the box

Patron Saint of Lost Yaks
posts - 203, comments - 734, trackbacks - 4

My Links

Advertisement

News

Archives

Post Categories

October 2009 Blog Posts

New article series going on by Itzik Ben-Gan

I recommend you read it. Next part will contain a brilliant solution for calculating concurrent sessions in a linear algorithm. The math involved is very good indeed. First part is found here http://www.sqlmag.com/articles/index.cfm?articleid=102734 //Peso

posted @ Monday, October 26, 2009 11:34 AM | Feedback (4) | Filed Under [ Optimization SQL Server 2008 Algorithms SQL Server 2005 ]

Pass the Torch

Since I became a two-time winner of the "Phil Factor SQL Speed Phreak" competition, I was asked to host the next competition. You can find the competition here http://ask.sqlservercentral.com/questions/826/the-fifo-stock-inventory-sql-problem The "Phil Factor SQL Speed Phreak" competitions are about everyday problems and to get people come together and give input on how to solve the current problem in best possible way. Good luck! //Peso

posted @ Friday, October 23, 2009 9:24 PM | Feedback (4) | Filed Under [ Miscellaneous ]

10 days old

Here is the lates addition to my family. In this picture the boy is 10 days old. The project name is now decided as "Johan Samuel Peter", username Samuel.  

posted @ Sunday, October 18, 2009 2:07 PM | Feedback (5) | Filed Under [ Miscellaneous ]

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 benefits of no logging etc etc. But yesterday I wrote a query for Phil Factor's "Subscription List" competition where I had choosen a table variable for the same reasons as before. It took a while to realize why (in this case) the solution with a temporary table was 30% faster than the solution...

posted @ Thursday, October 15, 2009 3:24 PM | Feedback (0) | Filed Under [ Optimization SQL Server 2008 SQL Server 2005 ]

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 born without complications at 5:06 am. Big sisters Isabelle (23 months) and Filippa (5.5 yr) are anxiously waiting for mother and new baby to get home. //Peter

posted @ Sunday, October 04, 2009 6:21 PM | Feedback (4) | Filed Under [ Miscellaneous ]

Powered by:
Powered By Subtext Powered By ASP.NET