Browse by Tags

• Algorithm
• Optimization

• 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

• Date and Time concurrency

  In the past I mostly have given the advice to break down all date intervals into the smallest part (often minutes) and then group by the minute. -- Prepare sample data DECLARE @Data TABLE ( RecID INT IDENTITY ( 1 , 1 ) PRIMARY KEY CLUSTERED , CreateDate Read More... Posted Saturday, September 19, 2009 1:51 PM by Peso | 0 Comments Filed under: Algorithm, Math

• Moving average and Weighted Moving Average

  In my previous blog post , I wrote about how to calculate median value and weighted median value in a secure and fast approach. In this blog post I am going to describe how you can calculate a fast moving average and also calculate a fast weighted moving Read More... Posted Friday, September 18, 2009 11:03 AM by Peso | 3 Comments Filed under: Algorithm, Math, Optimization

• Median and Weighted Median calculations

  Hi all! This is my first blog post here at sqlblog.com after some convincing arguments made by Adam Machanic. Some of you know me as Peso, and I have mostly blogged at SQLTeam.com before. Yesterday Joe Celko posted a query on microsoft.public.sqlserver.programming Read More... Posted Friday, September 18, 2009 10:02 AM by Peso | 13 Comments Filed under: Algorithm, Math, Optimization