Hi Nevyn,

Thanks for the reply. Online indexing rebuild happening on my environment. Though, we had an time out issue.

thanks grant and please suggest me if it not enable will it affect performance. How drastically it affect the performance?

Hi Grant,

i tried to run the below command on the sql i got all the output value as 0

DBCC TRACESTATUS (2371);

Output :

What does this means. Please advice...

Hi Nevyn,

your second line is the correct issue.

are you saying that right now you have a daily job rebuilding indexes, and your exe's time out while they are being rebuilt?

Thank you Scott for the knowledge sharing.

Hi Grant,

I am using enterprise edition only.

thanks a lot for your knowledge sharing. it is really helpful to understand. Still i need to learn before taking any decision.

thank you dwain for your precious time to mentor me. Looking for others suggestion as well.

thank you dwain for your explanation. The reason why i am asking, is i have some exe's which have some program running on that time and it produces time out....

Your requirement is little confusing. Below are my questions.

1. How are you subtrating the 30 days from JE_DATE? JE_DATE is an integer as you said

2. The reason for your error...

Can you please post sample data to play with and what output you are looking for.

I hope group by will do the trick.

Hi Dwain,

thanks for the reply and i copied data i posted and ran. it didn't throw any error. Also below is my another try to get the required output.

data:

declare...

Hi,

Do you have your local db to play with? I have couple of questions to move forward.

Are you able to connect to the database with username and password? If not,...

Hi Eirik,

thanks for your reply. Yes, your diagram looks perfect for me. i am not missing anything here. any help please

Guys, any Suggestion please

Hi Scott,

thanks for your suggestion and i already removed coalesce because IsProcessed column is not null. Even i mentioned in previous thread.