Pergunta de entrevista da empresa Bromcom Computers
If a SQL stored procedure takes too long to run what will you do first?
Resposta da entrevista
Sigiloso
14 de dez. de 2022
If you're running the same exact SQL as the stored procedure and the times are that different, your stored procedure is probably relying on metadata that is out of date. Try updating statistics or recompiling the stored procedure.