coolchaitu (8/3/2015)
Yes sir, i am the junior dba
So escalate it to your boss. This isn't an issue for a junior. Whilst he's dealing with that, get yourself some decent indexing articles and study them. You cannot escape TSQL if you wish to call yourself a DBA so you will have to learn that too.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden