.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Can parition aggregation aggregate correctly at the edge of the partitions?

Posted By:      Posted Date: September 20, 2010    Points: 0   Category :Sql Server

If I have a fact table at day level. I create a series of partitons on it based on month. Say, the first partition is for Jan, 2010. The second partition is for Feb, 2010 and so on. I have aggregates calculated on weekly level at each partition. If week 5 is spread over two partitions: 3 days in Jan/2010 partition and 4 days in Feb/2010 partition. Is week 5's aggregation data calculated correctly on Feb/2010 partition? In another word, will the aggregates pull the first 3 days from the Jan/2010 partition automatically or instead week 5's aggregation is not calculated at all?

Thanks a lot.

View Complete Post

More Related Resource Links

Will processUpdate of a dimension invalidate all paritions' aggregation even though some partitions


I have measure groups partitions by year. I have fact tables and dimension tables updated every day and only current year's fact data and related dimension members will be updated(insert/update/delete dimension members). For measure group partition, I will only update the current year partition. However, if I use processUpdate to process the dimension, will the aggregates on previous years' partitions be invalidated? Actually, the dimension update does not change data in previous years' partitions. Will the aggregates in these partitions be invalidated or not?

Thanks a lot.

Built-in Functions - Aggregate Functions

Aggregate functions return a single value summarizing a given data set. All aggregate functions are deterministic. NOTE: AVG, SUM, STDEV, STDEVP, VAR and VARP functions cannot operate on BIT data types; they can operate on all other numeric data types.

Category attribute of user control property does not work correctly in categories tab.



I have a User Control (ascx) and a property which a want to display in my categories tab in Visual Studio in the category named "Styles".

[Category("Styles"), DefaultValue(""), Description("The value for formating something.")]
public String MyFormatProperty
set { /* the code for set */; }
get { /* the code for get */; }

And here is the problem: Actually I do not need a get, because I only have to set the property (write only property). But when I omit the get, the property is displayed in the "Misc" category in the categories tab in Visual Studio. Only when I code the get as well, then the property is displayed correctly in the "Styles" category in the categories tab in Visual Studio.

Does anybody know why? How can I display the category correctly only with set?

Thanks, S.

Cutting Edge: Don't Worry, Be Lazy


Being lazy in software development can be a good thing, but until the Microsoft .NET Framework 4, coders had to implement lazy behavior themselves. Dino Esposito shows how to use the new Lazy class to maximize your resources.

Dino Esposito

MSDN Magazine August 2010

Cutting Edge: Expando Objects in C# 4


The .NET Framework 4 introduces some new features that enable you to go beyond static types. We explore dynamically expando objects and demonstrate how they can be used like dynamically updatable dictionary objects.

Dino Esposito

MSDN Magazine July 2010

Cutting Edge: C# 4.0, the Dynamic Keyword and COM


Are you a Microsoft .NET Framework programmer who struggles with critical legacy applications using COM objects that are beyond your control? Dino Esposito shows how to lessen the burden by going dynamic.

Dino Esposito

MSDN Magazine June 2010

Cutting Edge: Using the Dynamic Keyword in C# 4.0


C# 4 provide a new dynamic keyword that enables dynamic typing in what has traditionally been a strongly typed language. We explain how the dynamic keyword works and what it offers that casting, var, and System.Object cant' match.

Dino Esposito

MSDN Magazine May 2010

Cutting Edge: Revisiting Asynchronous ASP.NET Pages


If you need to scale up an existing Web application, you should first look to asynchronous operations, says Dino Esposito. He explains how new features coming in ASP.NET MVC 2 make this easier.

Dino Esposito

MSDN Magazine April 2010

Cutting Edge: ASP.NET Ajax Library and WCF Data Services


This month Dino takes a look at the JavaScript components coming in the ASP.NET Ajax Library and explains how they can be used for effective client-side data access.

Dino Esposito

MSDN Magazine March 2010

Don't Get Me Started: Edge Cases


Developers should focus their time and effort on the 99 normal use cases, rather than the one unusual use case that often gets way too much attention.

David Platt

MSDN Magazine March 2010

Cutting Edge: Predictive Fetch with jQuery and the ASP.NET Ajax Library


Dino Esposito builds upon his exploration of new data binding features coming in the ASP.NET Ajax Library, explaining how to implement the predictive fetch design pattern.

Dino Esposito

MSDN Magazine February 2010

Cutting Edge: Master-Detail Views with the ASP.NET Ajax Library


When you think of data-driven Web pages, most of the time what you really have in mind is a master-detail view of some cross-related data. Dino builds an example with ASP.NET AJAX 4 and jQuery.

Dino Esposito

MSDN Magazine January 2010

Cutting Edge: Live Data Binding in ASP.NET AJAX 4.0


Dino Esposito discusses various forms of client-side data binding as they are coming out in ASP.NET AJAX 4.0, focusing on some advanced features of data binding and observable objects.

Dino Esposito

MSDN Magazine December 2009

Cutting Edge: Conditional Rendering in ASP.NET AJAX 4.0


Last month, Dino covered the basics of the new DataView client control and the binding techniques most commonly used. In this article, he goes one step further and covers conditional template rendering.

Dino Esposito

MSDN Magazine November 2009

Cutting Edge: Data Binding in ASP.NET AJAX 4.0


In this article, Dino reviews the pillars of real-world AJAX development as supported in ASP.NET AJAX 4.0. In doing so, he mostly focuses on client-side templates and data-binding but doesn't ignore other goodies, such as ADO.NET Data Services proxy classes and programming facilities.

Dino Esposito

MSDN Magazine October 2009

Cutting Edge: Exploring ASP.NET 4.0-Web Forms and Beyond


The upcoming ASP.NET 4.0 platform has the same foundation as the latest 3.5 SP1 version, but it provides further refinement in the areas of Web Forms, Dynamic Data controls, and ASP.NET AJAX. In this article, Dino takes a look at what's new and improved in the Web Forms model.

Dino Esposito

MSDN Magazine September 2009

Cutting Edge: Pros and Cons of Data Transfer Objects


After a brief refresher on procedural and object based patterns for organizing the business logic layer, the author focuses on data transfer objects and the impact they have on the development of the software project.

Dino Esposito

MSDN Magazine August 2009

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend