October 2009 Blog Posts
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
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
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.
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...
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