June 2010 - Posts

• Relational division

  I came across an interesting post on Microsoft SQL Server forum this afternoon. It was a question about Relational algebra and the poster wanted to have an efficient query to solve his problem. The original title was " Select parent ids that have exact Read More... Posted Wednesday, June 30, 2010 10:03 PM by Peso | 7 Comments

• Another bin-packaging algorithm using recursion and XML

  This time I will show you an algorithm to do the dreaded bin-packaging using recursion and XML. First, create some sample data like this -- Prepare sample data DECLARE @Sample TABLE ( RowID INT IDENTITY ( 1 , 1 ) PRIMARY KEY CLUSTERED , Expense SMALLMONEY Read More... Posted Wednesday, June 30, 2010 2:42 PM by Peso | 0 Comments

• Ten days left

  As some of you know, I was awarded Microsoft Most Valuable Professional (MVP) for SQL Server in July last year. Now it's time to see if I get my MVP renewed, or if I lose the award. I honestly believe it's a good thing MVP status only lasts for one year Read More... Posted Sunday, June 20, 2010 10:22 AM by Peso | 3 Comments