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


Post New Web Links

Parition

Posted By:      Posted Date: September 14, 2010    Points: 0   Category :Sql Server
 
hi all, I need to create a partition on my fact table. The parition is based on a column called function_id. This is a int. The values for this can only 1 or 2. Can anyone show me how i can do this please?  


View Complete Post


More Related Resource Links

Parition Help

  
hi all, I need to create a partition on my fact table. The parition is based on a column called function_id. This is a int. The values for this can only 1 or 2. Can anyone show me how i can do this please?  In SQL SERVER 2008 Relational DB.. Can someone show me the steps for the above example, creating the parition function, schema etc... please help

Parition Function Help

  
hi all, I need to create a partition on my fact table. The parition is based on a column called function_id. This is a int. The values for this can only 1 or 2. Can anyone show me how i can do this please?  In SQL SERVER 2008 Relational DB.. I did this: CREATE PARTITION FUNCTION [pfDataSplitOnFunctionID](INT) AS RANGE LEFT FOR VALUES (1) GO CREATE PARTITION SCHEME [psDataSplitOnFunctionID] AS PARTITION [pfDataSplitOnFunctionID] ALL TO ([PRIMARY]); GO ALTER TABLE fact_revenue ADD CONSTRAINT chkFunctionID CHECK ([Function_ID] IN(1,2)); GO So I then do this: SELECT * FROM fact_revenue where  function_id  =1 And the query takes the as long as it did before the parition. Can someone help me understand were im going wrong?? Also do i need to delete the data then apply the partition then reload.. please help me were im going wrong?

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

  

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.


Categories: 
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