How do I Move Data from RO to RW Partition

Question

question

Ramakrishnan Nagasamy asked Jan 25, '11

How do I Move Data from RO to RW Partition

I have any application which has old data (as old as 8 years or even older). we are thinking of paritioning into RO and RW partitions. but sometime the older data gets modified. So how do we move data from Read Only Partition to Read Write Partitions before we can modify the data? Thanks

sql partitioning

3

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack ♦♦ commented · Jan 25, 2011 at 03:07 AM

can you tell us the server edition you are using please?

0 ·

Ramakrishnan Nagasamy commented · Jan 25, 2011 at 03:11 AM

SQL 2008. But planning to move to SQL 2008 R2. -ram

0 ·

ThomasRushton ♦♦ commented · Jan 25, 2011 at 03:12 AM

Then why is this tagged as an Oracle question?

0 ·

Answer 1 · 2011-01-25T00:53:36Z

Cyborg answered Jan 25, '11

If the older data needs to get modified then, why are you putting those into READ ONLY File groups? does that make any sense?

2

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Ramakrishnan Nagasamy commented · Jan 25, 2011 at 03:05 AM

Hi Most of the data in table doesnt change once its gone into past 1 year mark (about 80~90 mil records and about 95% chance that there will be no change). To improve perf, I would like keep them in RO partition. There are some odd cases where some 4 year old data is changed (according to business logic) and becomes new RW data. Hope this clarifies

0 ·

Cyborg commented · Jan 25, 2011 at 03:20 AM

@Ram, The better option for your scenario is to use READ_WRITE file group and To improve the performance use NOLOCK hint or set the Isolation level to READ_UNCOMMITTED TRANSACTION for your select queries, if you can compromise dirty reads.

0 ·

question