Data Warehouse Query Performance

The article on “Data Warehouse Query Performance” at http://technet.microsoft.com/en-us/magazine/cc434693.aspx is really good. It talks about the

  • Star join query optimization
  • Partitioned table parallelism
  • ROW and PAGE compression
  • Partition-aligned indexed views

    Enjoy Reading .

    Cheers!!!

    • Comments

    Post a Comment

    Popular posts from this blog

    Jesus - God Thinks of you.

    I received this mail and i thought its really worth to share. JESUS VS. Satan Satan went to visit Jesus in the Garden of Eden, and Satan came all happy and boasting. (Lk 4: 1-12; Job 1: 6-12) "Yes, Lord, now I have everybody captive, (well nearly everybody down there). I set traps, I used the baits of temptation, I know well what each one of them can't resist. I nearly caught them all!" (I Pet 5: 8-9; Eph 6: 10-17) "What are you going to do with them?" Jesus asked. and He was praying to God the Father. Satan answered "Oh, I am going to have some fun with them!" I'll make them divorce after they have married so the foundation of humanity will never be able to be established "the family" (Mt 19: 4-6; Mal 2: 16 ) I will make them hate each other and abuse each other, make them fall into alcohol and drugs without control. (Rom 13: 12-14) I will teach them to make weapons and bombs, so they kill each other "I am really going to have
    Read more

    ASP.NET 4.0 Feature - URL Routing

    Image
    Let’s see the new feature in ASP.NET 4.0 known as “URL Routing”. URL Routing is a feature which is driven by the ASP.NET URL routing engine which enables the application to route to custom urls instead of actual urls which may have some querystrings etc. In the past we have seen urls like http://localhost/NewStore/Titles.aspx can be now show as http://localhost/NewStore/AllTitles or http://localhost/NewStore/Titles.aspx?ID=2 can be now shown as http://localhost/NewStore/Products/Fiction . Doesn’t this look great? Now let’s see how do we achieve this. We would be using the “System.Web.Routing” class which products us a method “MapPageRoute” which helps to do the routing. Let us see a simple example where we would have two pages one which shows All the Titles and another which shows Title for a specific Author Id. For this example I am using the Pubs Database. We would have to first create the two new Pages “Titles.aspx” and “TitlesbyAuthor.aspx” . Now the “Titles.aspx” shows All the Tit
    Read more

    End of 2011 and Beginning of 2012

    The memories of the last new year 2011 is so fresh in my mind. It just shows how quick the year passed by. There has been always high's and low's in a year. On the professional front i did get a promotion. I did learn new stuff's on the technology front, but not to my expectation. The past year i have been little active on the social media (Twitter, Facebook). On the blog front, i could only manage to make 68 posts. On the personal front i did not take any vacations, that looks bad. On the Spiritual front, i did attend a couple of fasting prayers, sunday services and prayer meetings. Now the past is past, we can only look for a better tommorrow. Hope this year, will try to achieve things i could not in the last year. I am not planning to make any resolutions. I believe the guarding angels will be with me this year and praying to god to help me all my works. Wishing a Blessed and Prosperous Happy New Year 2012 to all my colleagues, readers, family and friends.
    Read more