March 2012 Entries
It still surprises me how many people set up the DateDimID as Identity(1, 1).If you use YYYYMMDD format, then on some reports, you can even display the date without navigating to the Date dimension to show label. In the same deal, you can use YYYYMM for a monthly date dimension, and YYYY for a yearly date dimension.[Update 2012-10-16]I now realize that what I said before was a clunky way to build dimension (hey I didn't say I was the expert. :D) And using only that argument going up against Kimball's ......
Whenever I start doubting my design of Data Mart or Cube, I always come back to this article and read it again. It helps me keep my design simple.
http://dwbi1.wordpress.com/2010/06/17/one-or-two-dimensions/Great post!
Related post:
http://dwbi1.wordpress.com/2011/02/26/denormalising-a-fact-table/
This is just one of those cool post which are not written as often as it should be. Hats off to Glenn Berry for stating it so clearly for all BI / database developers.http://sqlserver... read some Microsoft paper on "Fast Track Data Warehouse Architecture", and did not appreciate the benefit at the time. What a great way for developers to start with someone already figured out the licensing + cost + performance. There ......
Some very useful diagrams here. It provides a basis point. I see that it already does not really fit all project requirements, but this is a really nice starting point, and a good check on business entity relationship.
http://www.databaseanswers.org/data_models/index.htm
This is nothing new, just a way for me to organize the information better. Personally, I like the first 2 ways better just because I can order the result set any way I want.USE {Database Name}GO-- SQL 2008, search table nameSELECT IS_C.COLUMN_NAME , IS_C.* FROM INFORMATION_SCHEMA.COLUMNS AS IS_CWHERE IS_C.TABLE_NAME = '{Table Name}'ORDER BY IS_C.COLUMN_NAME -- , ORDINAL_POSITION, IS_NULLABLE, DATA_TYPE-- SQL 2008, search column nameSELECT IS_C.COLUMN_NAME , IS_C.* FROM INFORMATION_SCHEMA.COLUMNS ......
Hurray for the Enterprise Library developers! Always a big fan of your work.
http://entlib.codeplex.com/wikipage?title=EntLib5Azure&referringTitle=Home
http://entlib.codeplex.com/releases/view/75025
Watch the video here: http://channel9.msdn.com/posts/Autoscaling-Windows-Azure-applications
I had a bad experience working with Indexed view because, well, I didn't have much experience working with Indexed View. I hit 5 major issues before I finally gave up.Indexed view does not allow GETDATE() because it's a non-deterministic data type. I could not limit my result set, or put a flag column based on the age of the record.Indexed view does not allow self joinIndexed view does not allow OUTER JOINIndexed view does not do COUNT(*)Indexed view does not allow subqueriesIndexed view does not ......