Microsoft Bob

NOTE: The views expressed on this blog are my own and may not reflect the views of Microsoft
Posts
  • Microsoft Bob

    SQL Data Warehousing – Tip 2 – Indexed Views

    • 0 Comments
    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 going to look at how...
  • Microsoft Bob

    SQL Data Warehousing Tips 1 - Building a Period table

    • 0 Comments
    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 data warehouse tips....
Page 1 of 1 (2 items)