I agree with you guys, Actually, I was fixing one of the issue on SQL Server called timeout error. All of a sudden my all processes are failing and getting...

I know it does not matter but my question is why using rebuild index command does not make logical fragmentation to 0%.

May be it is related to filegroup space...

I am extremely sorry about that. Here is the code. I think some user running this old fashion query.

When user runs this query, it returns results pretty quickly. When...

Debbie, You are right. There are some people in this form are rude and frustrated from there life. I really ignore them and don't pay attention at all.

I think this...

Thanks man. I will go through this book.

Created the index which you have recommended , it's really improved the performance. it is now taking 4 sec.

How you came up with this following index. I still cannot see...

I am sending you the attached text file which has statistics io on query when I run first time and second time.

If you have noticed that when I ran the...

But in the execution plan , it's taking only clustered index seek. I am sending again attached execution plan.

I also ran the script to check the missing index on this...

Thanks David,

I don't see any lookup in the execution plan. ?

I already did that testing and I did see logical reads are so many but in the execution plan is taking clustered index seek.

I have attached the execution plan....

Sorry , I did little mistake in previous reply.

When I run the query with joining view first time it takes around 6 minutes but when I run same query second...

I have noticed one more thing. My partition is based on post_pd and the query I am filtering with SER_DT which not partition field.

so when I run the followng query...

The wired thing is, when I run the query with joining view first time it takes around 6 minutes but when I run same query second time it takes 33...

How can I post the execution plan. ?

If you have noticed , first query is using view, the name of the view is Transac and the secound query is using...

Here are both the queries and also IO stats. I have noticed one thing that view is using transac_archive table even the date range does not fall in Transac_Archive table....