.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

Merging Partitions

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


Hi There,


I have a quick question regarding merging cube partitions.

If I create partitions sliced by date (let's assume we have year level partitions like 2006,2007,2008...)

Later, if I want to merge selected partition to another partition , for example I have history partition and 2006 partition and I want to merge 2006 to history partition then I can simply merge them using ' merge partition' through Management Studio.


My question is that in script, History partition has condition which is where clause and restricted by year level (i.g. WHERE date < '01-01-2006' ) ; however after merging , script won't change like WHERE date <'01-01-2007').


If so, whenever I merge partitions then I have to alter the script as well based on selected merge partion?

I need to refresh history partition once a month;however even if I merge 2006 partition , once I reprocess history partition then it only process what it was wrote in script. So, after reprocessing 2006 data won't appear in this history partition.

So, wondering it's mentatory to alter the script once partition is merged.

Please give me some comments on this issue

View Complete Post

More Related Resource Links

merging multiple tables in a single dataset to single table


 i have a stored procedure which returns three tables to a dataset ..... now i need to merge all three tables to a single table from d same dataset 

like dataset1 has table1 table2 and table3 .... i want all the three tabels to be merged into dataset1 itself .... instead of three diffrent tables so that i can show all three table data in a single datagrid  as a compact data and combination of 3 tables from d single dataset.....

can some1 help me please.....

Merging PDF documents


I've generated some PDF documents.
But i like to merge all PDF documents to 1 PDF document, withouth saving it first.

So i would like to have 10 byes ans bound them together if possible...
But how?

Code i use right now:

////Then create new pdf file
            string strMime = null;
            string strEncoding = null;
            string strfileNameExtentions = null;
            string[] stream = null;
            Microsoft.Reporting.WebForms.Warning[] warnings = null;
            bytes = rep.Render("PDF", null, out strMime, out strEncoding, out strfileNameExtentions, out stream, out warnings);      


Office Services: Merging Word Documents on the Server Side with SharePoint 2010


Office 2010 and SharePoint 2010 include a new set of components called Application Services. These put a rich set of tools in a developer's bag for Office automation. We'll show you how to use Office OpenXML, Word Automation Services and SharePoint to build a simple application that merges separate status reports into a single document.

Manvir Singh, Ankush Bhatia

MSDN Magazine July 2010

Assembling Documents on SharePoint 2010 Sites by Merging Content from Excel, PowerPoint, and Word

This article describes a rich document assembly solution that takes Word 2010 documents, Excel 2010 documents, and PowerPoint 2010 documents and merges them together to form a final report in Word. It does all of this from a SharePoint 2010 Web Part.

using CompositeCollection in ListBox for merging two Typed DataTable

Hi i have a Typed DataSet contining two DataTable : Table1 , Table2 i want to merge the two Tables in a ListBox by using "CompositeCollection " , but this doesn't work <ListBox.ItemsSource> <CompositeCollection> <CollectionContainer Collection="{Binding Path = Table1}"/> <CollectionContainer Collection="{Binding Path =Table2}"/> </CompositeCollection> </ListBox.ItemsSource> i put also : public partial class Window1 : Window { public Window1() { InitializeComponent(); this.FillDataset(); this.DataContext = ds; //this.Resources.Add("mytable1", DataSet1.Table1); }   i want to confess i don't have a clear idea about referencing an object as a Typed DataTable. also if a want to Template my ListBox lique this :    <ListBox.ItemTemplate> <DataTemplate DataType="{x:Type myprog:DataSet1+Table1 }"> <StackPanel Orientation="Horizontal"> <TextBlock Text="{Binding Path=ProductName}" Background="AliceBlue"/> </StackPanel> </DataTemplate> <DataTemplate DataType="{x:Type myprog:DataSet1+Table2 }"> <StackPanel Orientation="Horizontal"> <TextBlock Text="{Binding Path=ProductName}&quo

SQL Reporting - Merging fields into document

Currently, we have a process setup that has a user create a merge in the application, then that merge is dropped into a .csv file onto the root of the c: drive of the individual's PC... they then take the .csv file and use macros within Word and run a merge process into a document template... (these are documents that are sent to the court for renewal of an expired legal process)..  I'd like to know if there is a better way of doing this? Is there a way of eliminating the .csv file and the merge process of Word, and keep everything within SQL and the Reporting services?  Any help in pointing me to the right resources for this would be appreciated. Thanks! jill

how ssas generate sql queries when processing dimensions and partitions?

hi all, how does ssas2008 generate sql queries to read data from the source, where processing dimensions and partitions? is there any reading meterial that clearly explains how the sql queries are constructed according to properties of dsv, dimensions and measures and partitions.   thanks in advance.Andrew Chen Interested in BI related technologies

Multiple Partitions, datafiles/logfiles on VMWare

Hi, I have multiple databases, actually a BizTalk environment with 10 Microsoft databases.  An recommended optimzation is to split the data files and log files onto seperate partitions/LUNS. Does this make sense in VMWare? Secondly, does it make sense to group all log files in one directory ?   Thanks, Ben

Fact table in DSV vs partitions pointed to a different table

I am seeing an issue in my cube for a partition that is based on a separate table than the Fact table in the DSV. I have 8 partitions all from different physical tables. In the DSV I used 1 of those 8 partition tables as the "source" of the DSV so I could model the relationships between the fact and the dimensions. On 1 of the 8 it loads over 1 million rows from the partition into the cube, but when I use the browser to show the count in that particular partition it shows the exact same number of records that are in the table that was used in the DSV. The strange thing is all the other partitions work fine except this 1. I have deleted the partition and added it back multiple times and cant get it to work right. Has someone seen this problem before?   I have run into this a couple times, one way of fixing it was to recreate the entire project in a new project, copy all objects from the old projects and rebuild. I cant seem to figure out another way of fixing this.Craig

Merging overlapping data from two databases?

We are decommissioning an older server (2000) and are in the process of migrating all the DBs to a nice new server (2005). One particular database was backed up and restored to the new server, BUT not all applications were re-pointed at the instance on the new server, they were left pointing at the old instance on the old server. Result: We have almost an entire day where some data was inserted into one DB, and some data was inserted into another. I've been handed the task of getting the data that went to the old server onto the new one. I've re-backed up the Db and restored it as a separate instance on the new server and I've been able to compare the two.  The "old" instance has about 675 records I need to get onto the new instance. Problem: 1. Trying to avoid writing a separate query for every single table in the DB, comparing the old and new instances, and inserting.  "IS NOT IN" or something similar.  I could do that but I'm swamped with work.  This project was NOT on my to-do list yesterday, but lots of other stuff was.  Anything quicker available? 2. Identity: Since the new instance took up where the old instance left off, and the old instance carried on as if nothing had changed, almost every row in every table has PKs duplicated in the other instance, but relating to a different data set. Besides shooting the individual

Get the row position of the group? merging query?

Hello! I am using SQLS2005. I have two tables: Unit: UnitId int PK Title varchar UnitOption: UnitOptionId int PK UnitId int FK Title varchar Quote: QuoteId int PK UnitOptionId int FK Title varchar I want to create a scalar UDF that takes a QuoteId param and returns a varchar that contains the following description (pseudu): Quote.Title + '-' + Unit.Title + '-' + Unit.UnitId + /* Here is where my question is: If there are more than 1 UnitOption under this Unit, then return '-' + the UnitOption number under this Unit (i.e.) if under this Unit, there are 3 UnitOption with IDs 13, 17, 55 under the unit, and the current Quote.UnitOptionId is the 17 one, it should return 2. Which means I want to retrieve an ID of this row in the group. Else return '' */

Merging 2 crystalreport into 1

Alright, I have been search through the net to combine 2 reports into one. I know about the subreport but I can't merge them in my case.I have one report with data being added into the report at runtime and another report having images being added to it at runtime as well.I tried inserting both of them to another report as a subreport but I get nothing out of it. Its blank! I was wondering if subreports only works if the data are either static or being drag out from a database. Ultimately I want to export them as a single PDF. Here's my code. AllReadings report = new AllReadings();Graph graphReport = new Graph();report.SetDataSource(readings);graphReport.Database.Tables["Images"].SetDataSource(data);Combine cbreport = new Combine();Stream stream = cbreport .ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);The cbreport holds 2 subreport. One being AllReadings and the other is the graphReport. Is there any other ways to combine them both together?

merging every 3 column in excel using macros

I would like to merge every 3 columns and so forth in excel. It will be as follow: Column A,B,C as one column continued with  D,E,F, and G,H,I, and so forth until say KU,KV,KW. please let me know how to create the macros to select and then merge it. Thank you

Backing up databases with large partitions in AS2005

  Hi,   While ago I reply to a thread regarding this issue, see http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-olap/11643/Backing-up-databases-with-large-partitions-in-AS2005. I think the original forum is no longer available.   This week I got a similar problem, now we are not able to create and restore a abf for a cube with a .fact.data file with size of 4.39 GB. We are in a Win Server 2003 Enterprise Edition SP2 (IA64) . The SSAS version is 9.00.4035.00 (SQL Server 2005 Service Pack 3 ). We did the following steps: Create the .abf in SSMS compressing the data of the <database name>_2010 . Restore it in the same server with the name <database name>_201008 . We are not able to browse the cube in <database name>_201008 . If we unprocess the partition with the .fact.data with size of 4.39 GB, then the cube browses without problems. We then copy the .fact.data from the <database name>_2010 to <database name>_201008 and then the cube from <database name>_201008 browses correctly! I can add that the database was processed in Win Server 2003 Enterprise Edition SP2 (x86) (with SQL Server 9.00.3228.00 - Cumulative update package 6 for SQL Server 2005 Service Pack 2 ) and then synchronized to the Win Server 2003 Enterprise Edition SP2 (IA64) (also 9.00.3228.00) without problems. In the original thread Peter Yang [MSFT] stated th

merging two textfiles along with filename

Hi Team, I wantto build a package which takes input from .txt files and write in abc.txt along wiht the file name so if input is file a.txt content is lksjklsslkjfksf sfjsdkjflsd file b.txt content is lksjklsslkjfksf sfjsdkjflsd  then output abc.txt should be a.txt lksjklsslkjfksf sfjsdkjflsd b.txt lksjklsslkjfksf sfjsdkjflsd   Please give me some suggsetion on how to do it its like inserting file name then data in the same column Regars, Eshwar    

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.

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