Partitioning Strategery

Hi all,

I've got several large fact tables that I want to partition by time. What's the best way to strategy to manage this? I have a C# app that uses AMO to manage the re-processing currently, but right now I'm fairly naive and just re-process every measure group.

What I'd like is a way to automatically partition by month / day [depending on measure group], and then enhance my re-process app to only process the latest partition.

My current idea is to establish a naming structure for the existing MGs/partitions, [i.e. "Foo 12-2006"], parse the date, adjust the named query, create a new partition if needed, and re-process if appropriate. Though it's quite doable, it seems a bit complex for something that should be a more of a mainstream scenario.

How have you guys implemented this functionality? I saw something about specifying the "slice" dimension on partitions, but I'm not sure if that can be used to help this.

Cheers,

Arjun

The follwoing is my experience for different cases when refreshing data in a partitioned cube.

C1. New data for a new time period

Incrementally processing the time dimension, creating the new partition for the new time period and fully process it.

C2. New data for existing time period

Create meta data in RDBMS such as batch etc, merge the new data into existing partition

C3. Updated or deleted data for existing period

Fully process the partition

In SSAS2005, slice is automatically set for msolap partition, and it is only used for querying, not for processing, so you maybe need not to consider it at all.

|||

CJ - thanks for your insight.

Typically my cases fall under (C1) - new data for a new time period. What's the best way to manage new partition creation? Does SSAS provide any functionality to make this easier, or do I need to build my own infrastructure?

|||

If a partition strategery works for you, it is a good one.

I always build the partitions logic by myself.

Partitioning performance on one disk?

Hi,

I know partitioning improves the performance on large tables.

We have a table of app. 100.000.000 records.
We want to partition the table, but we were wondering if there is still an increase in performance if all the partitions are on the same disk. We want to partition the data per month, but we don't have any disks left were we can spread the partitions.

So my main question is:
Is there still a performance increase when you use partitioning on one disk in stead of multiple disks.

Thx!

Regards Tony

sure. though the gain is maximized when you partition across multiple disks and the system is running on multi cpu.

parent child - get all children for a specific row

Hi,
I am trying to create a bulletinboard app. So I have a thread table
with parent/child relation.
How can I on a specific threadID get all its children ?
Any help/hints will be greatly appreciated :-)
Regards
SayaIf you have SQL Server 2005, check out "Common Table Expressions" in the
BOL.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Saya" <vaqas@.hotmail.com> wrote in message
news:1149257162.442872.321450@.i39g2000cwa.googlegroups.com...
Hi,
I am trying to create a bulletinboard app. So I have a thread table
with parent/child relation.
How can I on a specific threadID get all its children ?
Any help/hints will be greatly appreciated :-)
Regards
Saya

parent child - get all children for a specific row

Hi,
I am trying to create a bulletinboard app. So I have a thread table
with parent/child relation.
How can I on a specific threadID get all its children ?
Any help/hints will be greatly appreciated :-)
Regards
SayaIf you have SQL Server 2005, check out "Common Table Expressions" in the
BOL.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Saya" <vaqas@.hotmail.com> wrote in message
news:1149257162.442872.321450@.i39g2000cwa.googlegroups.com...
Hi,
I am trying to create a bulletinboard app. So I have a thread table
with parent/child relation.
How can I on a specific threadID get all its children ?
Any help/hints will be greatly appreciated :-)
Regards
Saya

Parameters in url to make GIF question.

What parameter can I send from my app that will render the report and
then instantly convert it into a .GIF file?
thanks,
TrintTrint,
There isn't a parameter you can pass to get an exported parameter as a gif
file.
Take a look at the url below to view supported export formats:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rswork/htm/rwp_workingreports_v1_3nxt.asp
The below link shows the available URL access params:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_urlaccess_374y.asp
Adrian M.
"trint" <trinity.smith@.gmail.com> wrote in message
news:1105737359.995271.243600@.z14g2000cwz.googlegroups.com...
> What parameter can I send from my app that will render the report and
> then instantly convert it into a .GIF file?
> thanks,
> Trint
>|||I know TIFF but can you export to GIF also. ?
for TIFF you supply
rsFormat=IMAGE along with other report parameters.
"trint" <trinity.smith@.gmail.com> wrote in message
news:1105737359.995271.243600@.z14g2000cwz.googlegroups.com...
> What parameter can I send from my app that will render the report and
> then instantly convert it into a .GIF file?
> thanks,
> Trint
>|||OK,
I figured out how to render .gif...here it is:
"The Image rendering extension renders a report to a bitmap or
metafile. By default, the Image rendering extension produces a TIFF
file of the report, which can be viewed in multiple pages. When the
client receives the image, it can be displayed in an image viewer and
printed.
The Image rendering extension can generate files in any of the formats
supported by GDI+: BMP, EMF, GIF, JPEG, PNG, and TIFF. For TIFF format,
the file name of the primary stream is ReportName.tif. For all other
formats, which render as a single page per file, the file name is
ReportName_Page.ext where ext is the file extension for the chosen
format.
"
Trint
Vaibhav wrote:
> I know TIFF but can you export to GIF also. ?
> for TIFF you supply
> rsFormat=IMAGE along with other report parameters.
> "trint" <trinity.smith@.gmail.com> wrote in message
> news:1105737359.995271.243600@.z14g2000cwz.googlegroups.com...
> > What parameter can I send from my app that will render the report
and
> > then instantly convert it into a .GIF file?
> > thanks,
> > Trint
> >