Even this would work.SELECT DISTINCT [YEAR], ID, 1 AS [ID_COUNT]

FROM @test_data

If these 2 nonclustered indexes have only index seeks in sys.dm_db_index_usage_stats then most likely you can drop them without sacrificing performance too much, but if there are a lot of...

I don't know how big is tblBidMaster tables, but an index on CityID should help. You can also try to create an index as suggested by optimizer itself:CREATE NONCLUSTERED INDEX...

Jayanth_Kurup (7/23/2015)

---

@Op instead of using temptables , you could try using recompile hint and see if the performance improves. Using a temptable just to avoid problems with the base table...

In some cases the best solution might be to split very complex query apart using temp tables. This query is definitely not an easy one for optimizer and it tells...

Seriously? Look at your...

DavidDroog (7/22/2015)

---

Hi Guys

thanks for the replies.

@Drew - Sorry, not sure I follow. I am using the inner joins as the filter. The full query is actually dynamic and this is...

In most of the cases this will return you plan from the cache for the currently running statement:

select

s.session_id,

r.plan_handle,

substring(h.text, (r.statement_start_offset/2)+1 , case when r.statement_end_offset IN(0,-1)...

keshab.basnet (6/26/2015)

---

We face slow performance issue for like taking long time for same query execution after We apply index rebuild and reorganize index. But, after execution of query or procedure...

Mircea (5/21/2015)

---

I did not urge anyone to use the script, so please short of explaining exactly why - do not urge anyone to do anything else but analyse the script...

The query has no sense at all! I urge everyone not to use it.

This join based on spid is simply wrong

from #cpu2 c2 join #cpu1 c1...

And you already checked that before and after query plans are the same?

What about wait stats during that time? Any abnormality?

Get rid of the loop. This should be your performance concern.

From Resolving Indexes on Views

Why do you need to drop procedures before upgrade?

Why do you need to drop ALL procedures before upgrade?

I strongly suggest you to rethink your upgrade strategy.