any advice ?

i have a database in a Simple mode, full backup every sunday and differencial every night. I added 12 filegroups/files ..

What is the best way to backup/restore...

I found an article that mention that I can have 1000partition in a table.

i have a range of records that I need to partition. My range is from 360000000 to...

Im attaching a file where you can see the partitionId of the Join. It uses the Clustered Index. I actually tried using another index that is partitioned as well with...

Yes, I meant the Storing the Data which is expected to be added in the future.

I just worked on that and it looks fine.

Thank you so much!

I created all the partition for my existing data and for the next 6 months. Including filegroups and its files. I moved the indexes that are involve in the key...

nothing?

I have everything set. Im attaching 2 images, one of the Partition and other of the Partition Files so you can take at look.

What will happen with January2010? How...

morning.

this is the version:

Microsoft SQL Server 2005 - 9.00.3200.00 (X64) Oct 2 2007 12:23:02 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows...

Thank you John.

Im not done readind the document yet. Thank you for all the advices.

Regards,

I have the SQL Server 2005 Developer Edition.

This is my scenario on the same server right now:

ArchiveDatabase:

Table2008_1

Table2008_2

Table2008_3

Table2008_4

Table2009_1

Table2009_2

Table2009_3

Where each table contains 3 months of data, the _# means the...

Definitely I need to create Partitions in my tables; my process took 52minutes to move/delete around 44million records (3 months of data). Plus I have a view that union all...

Thank you for the advices

Hi Jason and Mark,

Thank you for your responds. My archive database is located in the same server. I have tables per trimester around 200,000 records each table (each trimester,...

non experience advice?

Thank you so much. I perfectly works for what I need.

Regards,