Monthly Archives: May 2009

SQL Data Warehousing – Tip 2 – Indexed Views

Posted on May 13, 2009 by Bob L

Last time we discussed the use of a period table to consolidate analysis into smaller segments of data.  This can be done for an analytical application where the details are not needed or as part of a rollup.  Today, we’re … Continue reading →

Posted in Uncategorized | Leave a comment

SQL Data Warehousing Tips 1 – Building a Period table

Posted on May 5, 2009 by Bob L

Recently, I started a personal project for analyzing stock market trends and calculating the optimal trading strategies.  I’ve learned a lot of new stuff about LINQ and SQL 2008 from this.  Based on that I’m opening a new series on … Continue reading →

Posted in Uncategorized | Leave a comment