Thanks a lot 🙂

Always post table defintion , index definition and sql code to get response faster

and also spend some time with the link For Quick Result in my signature.

i guess you have stored proc which creating problem if yes then u can ignore it's above part

like

create proc sp_name ( id int , parma varchar(300))as

and use remaining...

Frankly tell you this would be a intermediate/ working table ( prefebly a temp...

This can help you select serverproperty ('productlevel')

Refer this link alsohttp://technet.microsoft.com/en-us/library/ms189858.aspx

Rebuilding Indexes

Rebuilding an index drops and re-creates the index. This removes fragmentation, reclaims disk space by compacting the pages based on the specified or existing fill factor setting, and reorders...

Interesting

...

i am sure you must be aware of below text but i am just giving you bit support

Query to Identify Indexes that are not being used use dbname

go

SELECT o.name Object_Name,

...

I guess optimizer will not use seek for HAVING MIN(Date).What do you think ?

if you have index on...

select assetid,date

from

(

select assetid,date, row_number () over (partition by assetid order by date ) rowid from t1

WHERE date < inceptiondate ) t

WHERE t.rowid = 1

@BrainDonor

WHERE

(@CompanyLetter = 'ALL')

OR

((@CompanyLetter = 'OTHER')...

after seeing Execution plan, i should say CTE query working better the PIVOT one.

try this select TransactionID,

sum(TOT) as TOT,

sum(UniqueEnvs) as UniqueEnvs,

sum(GBX) as GBX,

sum(IEX) as IEX,

sum(UNK) as UNX,

DateTimeReceived

...