Thanks for your reply. Sorry for not providing the complete information. So this is how the table relationship is .

Product master---= product price -->order.

The order and the product price are...

Yes I am trying to fix performance issues. The fact column which has 15000000 records are all unique that's why I want to split this column as per the above...

They must be done individually.After a database has been enabled for change data capture, members of the db_owner fixed database role can create a capture instance for individual source tables...

Thanks Gila monster for your comments .However for interviews people do not ask simple question on SQL hence you are seeing unrealistic example.

Thanks Sean Lange for your reply.

1) Yes you are correct the rowcount should be set back to 0. So I have modified the query to below

SET ROWCOUNT 1

select * from...