question

Ramakrishnan Nagasamy avatar image
Ramakrishnan Nagasamy asked

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
sqlpartitioning
3 comments
10 |1200

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

can you tell us the server edition you are using please?
0 Likes 0 ·
SQL 2008. But planning to move to SQL 2008 R2. -ram
0 Likes 0 ·
Then why is this tagged as an Oracle question?
0 Likes 0 ·

1 Answer

·
Cyborg avatar image
Cyborg answered
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 comments
10 |1200

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

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 Likes 0 ·
@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 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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