I have a master table T1 which has 1000 records and a ColRef a key column. There are lots other tables all linked by ColRef.
I have a Stored procedure which takes few hours to process. I want to split this process like creating a view from T1 select records like 1 to 250, 251 to 500, 501 to 750, > 750. and run this from a .Net program. I cant make changes to any of the SQL components, including procedure or views. instead if pass a hint from my 4 instances of program to run different sections of data. Looks like an impossible situation, but could someone come across this kind of situation.
The whole process takes 8 hours, if I can split into 4 instance and run in 4 different servers(but one database) would take around 2 hours theoretically.