---- QUESTION START --------
If you have a report in your web application, your are loading data to this report from SQL SERVER db and this report is having performance issues like taking forever to load, affecting entire website.
What steps you would take to resolve the slowness issue and make the report load as quickly as possible.
----- QUESTION ENDS --------
----- FURTHER EXPLANATION ---
I have been asked above question in several interviewS, I answered this question as per my knowledge and experience. but I think it did not impress interviewer. Its a very IMPORTANT question..
Hence I would like to know answer of this question as per your PRACTICAL EXPERIENCE, EXPERTISE and WORK KNOWLEDGE.
I don't want to search this question on google, because I know part of answer based upon my knowledge. But I want to see if their is a room of improvement for this question.
So, I would appreciate answers based upon your expertise and personal experience rather than posting some google links.
Thanks in advance