Sign in
Microsoft Bob
NOTE: The views expressed on this blog are my own and may not reflect the views of Microsoft
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Options
About
Email Blog Author
RSS for posts
RSS for comments
OK
Search
Tags
.NET
.NET Tips and Tricks
COBOL
CodeProject
DDL Trigger
Development Methodology
Fusion-io
future RDBMS
High Availability
Indexed Views
in-memory database
PCIE SSD
Software Architecture
SQL Partitioning
SQL Performance
SQL Server
SQL Server 2005
SQL Server 2008
SQL Server Indexing
SQL Server Performance
SSD
SSIS
SSIS Tips
T-SQL Tips and Tricks
Visual Studio.NET
Archive
Archives
October 2012
(6)
April 2012
(1)
March 2012
(1)
February 2012
(1)
October 2011
(1)
September 2011
(1)
November 2010
(3)
July 2010
(1)
June 2010
(3)
May 2010
(2)
November 2009
(1)
October 2009
(1)
August 2009
(7)
July 2009
(3)
June 2009
(1)
May 2009
(2)
January 2009
(1)
June 2008
(5)
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Microsoft Bob
SQL Data Warehousing – Tip 2 – Indexed Views
Posted
over 4 years ago
by
MSFT Bob
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
Posted
over 4 years ago
by
MSFT Bob
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)