Thanks Folks!!

it works! 😀

we have to publish the data near real time thats the reason we are fetching the data hourly.

actually the production server resources also sucks

below is the config :

Processor : 2.9...

Average row count = 12lakhs

hourly := 2-2.5 lakhs (include newly inserted and modified one)

Yes the SP is joining big transactions table (4 tables) and then getting the data. May...

Thanks for your reply!

I will tell u what exactly i am doing.

I am pulling data from one server (using Stored procedure )and inserting the data into table. when i am...

Please reply somebody

Thanks Kevin for sharing your thought.

As i said i am very confused about partitioning thing that's the reason this question came up. Yes i have done my home work,...

Hey Jeff!!

Thanks for your reply.

In my database, there is a transaction table whose row count is 117690142. There are index created on column but still when we fire any query...

Thanks a lot Folks!!

I will try to update at web app side.

Thanks once again

Thanks a lot Phil!!

OK!!

Below is the way i am following :

1 Created three variable Query, Sdate, Edate

a. Query = SELECT * FROM Table where date<= sdate...

HI!

Thanks for the reply!

I have to create batch of data column (Hourly batch) . Not able to understand

how to write ETL for processing data into batch.

Please help!

please reply somebody!

Thanks for the link!! Really appreciate!

However i am not able to figure out how to do this with Date column and how to pass to SQL command :crying:

Yes Exactly!!

want to process in batches.

Can u please help

Hi,

Thanks for the reply.

May be i have not cleared my question properly.

My transaction system has huge data and i have asked to pull the data of last 2 months in...