dinksha70 (9/23/2016)
If an interviewer ask you a question:"A report runs everyday (using a Store procedure). Just say it takes 15 min.to generate the report.
today it is took an hour. Every thing remains the same i.e. network, connections, users, etc..... nothing has changed.So what do you do first to find why did it take so long and what are the steps you take next?"
Please share your thoughts and experience.
Thanks
To be brutally honest, this is an "experience" question. If you don't have the experience, then any answer you provide will quickly be proven out that you haven't done such a thing before. You can preface the answer with "I haven't had to do such a thing yet but I've studied what to do and here are the steps I'd take". But then your going to have to prove that you've actually studied for such an event.
On that note and to be even more brutally honest, I don't provide answers to interview questions on forums because YOU need to make the investment in time researching such problems so that YOU can actually do the job if chosen for it. 😉 It's not like Yabingooglewho doesn't have any information on such events.
--Jeff Moden
Change is inevitable... Change for the better is not.