Thanks for the reply, but I don't know nothing about this server. Somebody was having some issues and my manager emailed me to look for the problem. So today was...

Thank you all, I will make some changes in that query and will run it again. Lets see what happens.

Thanks again.

Change Management.

Disaster recovery plan if the company has any?

List of DB which are problematic.

Planned maintenance window.

Who is responsible for applying patches?

Security policies.

Backup policies. How long your company keep the data.

Ticket/Escalation...

I did save the plan but I don't know how to copy it on my local machine.

Does this help?

This is the Query that I was running and it executed in 32 seconds. I checked the index fragmentation as well and its only 10% fragmented. Is it safer for...

This view is really small. I ran it production and it executed in 1 sec. Developers were having some other issues not related to DB. Thanks for help.

Thank you guys for taking some time out and giving me some amazing tips.

Thanks,

Stay thirsty my friend...lol