Browse by Tags
All Tags » SQL Server » Data Warehouse ( RSS)
-
|
If you glance to the side of this post you will see that one of the few books on my bookshelf is the Microsoft Data Warehouse Toolkit , and so I am annoyed that I can’t make the course of the book, presented by the authors, Joy Mundy and Warren Thornthwaite...
|
-
|
Working for Microsoft is strangely like working for the government, yu are essentially trying to please everyone, but there are significant minorities on any given issue who aren’t that satisfied. Let me explain with a real world example.. The lack of...
|
-
|
Fact tables should be narrow and deep. If you are recording every debit card transaction for every customer across the fifteen retail banks you own, you end up with 15 million rows a day, so to save space they need to be as thin as possible. ...
|
-
|
SQL Server 2008 offers more powerful relational data warehousing capabilities. Take a close look at key performance-related data warehousing features and find out how you can use all this new technology to optimize query performance. The article explores...
|
-
|
If like me, you are trying out the new stuff in SQL server 2008 you might need some data to work with. The standard Adventure Works sample databases for OLTP and data warehousing are not in the CTP nor is the the analysis services project. So you'll need...
|
-
|
Technorati Tags: BI , Business Intelligence , OLAP , SQL server 2008 Business Intelligence is just like digital photography, the more detail you want the more space you are going to use and in both cases we talk about grain and granularity. If you have...
|
|
|