Hi ,

I have implemented this logic at client side it helps to improve the performance

Before Logic (Time Taken) 18 Hr to 24 Hrfor 66 Rows

After change in logic (Time...

We are not updating the date column on which we have clustered index. I think even though it will update as we are updating other columns

Thanks for reply

3) Most importantly what is the hardware configuration?

-- Which are the particular hardware configuration parameters you require to further suggestions.

4) Have you done file IO...

Thanks Kevin for reply

3) Most importantly what is the hardware configuration?

-- Which are the particular hardware configuration parameters you require for further suggestion

4) Have you done file...

sure, I will check with support team and let you know.

I don't have direct access to the client server.

Yes, all those are tables

We are fetching data from different databases and all DBs are on the same server

Thanks for your reply.

There will be one bo.MedRecReviewID and it can be associated with many bo.MedRecReviewDetailID.

The query is returning 4 rows

1043655187379NULLNULL0

1043655193478NULLNULL0

1043655204245NULLNULL0

1043655213895NULLNULL0

I changed the query by following way but...

I have added attachment as this is not in sql intended format