yes statistics are updated

Thanks all for the support. Discussions are going on how to change the table design

Ya, but sorry query cannot be shared, I know that data will not be there, but sorry.

Will try to annonymize and come back

Sorry but its something like this

with wftbl(

select col1,..col5 from objectA

inner join objectB

on cond1 =cond1

where ...

)

....

tbl2(

object c

inner join

objectA

where . ..

)

select col1 .. .

from

maintabl

....

left join (select *...

Thanks and that makes it clear

Now I get a Index scan and Merge join, hope its better than a hash match & table scan when dealing with huge data volume.

Attached a test plan, Is it possible to avoid the table scan & clustered index scan in this scenario

Thanks for sharing the link

Sorry that I couldn't post my plan here. I agree to Luis C. and decided to go step by step.

I wanted some experts commenting how to analyze a very big...

NO because they wont allow to install 3rd party tools

No I dont have 🙁

Also I may have to move users as well

But I am confused with the approaches for migrating SSAS and SSRS could you guide me.

I found this topic in Microsoft website that describes migrating SSRS report

https://msdn.microsoft.com/en-us/library/ms143724.aspx

Have...

I just wanted to know the user name associated with the SQL Server agent.

If theer is any means to find that. it would be great

How can i set this permission?