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

    “Unable to retrieve the metadata for …” Error while using ASP.NET MVC 3

    While adding a controller in ASP.NET MVC 3 application, you might get a error “Unable to retrieve the metadata for …”. This error is due to the incorrect connection string name or the connection string in the web.config. I had encountered the same error and the issue was that the name of my DBContext was different from that of the web.config connection string name. When I made it same it was able to create the controller.
    Read more

    Visual Studio 2013 and .NET 4.5.1

    Microsoft released VS 2013 and .NET 4.5.1 . Some of the key highlights are as below Innovative Features for Greater Developer Productivity Support for Windows 8.1 App Development Web Development Advancements Create Modern Business Apps for Office 365 Debugging and optimization Improvements Expanded ALM Capabilities To read about them , please check out http://www.microsoft.com/visualstudio/eng/visual-studio-2013#story-2013
    Read more

    Getting Started with ASP.NET MVC, SignalR KnockoutJS

    Image
    This article describes a simple application intended to notify users when a new user is created. To build the same we are using the technologies like ASP.NET MVC 4, SignalR, KnockoutJS, ToastR, Twitter BootStrap. First lets create a ASP.NET MVC 4 Web Application. Lets add the SignalR, KnockoutJS, ToastR, Twitter BootStrap by using the Package Manager Console into the project. install-package knockoutjs install-package Microsoft.AspNet.SignalR install-package Twitter.Bootstrap install-package Toastr We added a new page "CreateUser.shtml" and the code looks like as shown below < h2>User Creation < script src="../../Scripts/jquery-1.9.1.js" type="text/javascript">     < script src="../../Scripts/knockout-2.3.0.js" type="text/javascript"> < script src="../../Scripts/bootstrap.js" type="text/javascript"> < div class="container-fluid">     First Name: < input typ...
    Read more