Lidl Interview Question
What do you do if you have long running SQL queries?
Interview Answer
Anonymous
Feb 22, 2021
I use SQL Server estimated execution plan to find out why the query is taking so long, if we are missing indexed, if the query is performing index scans instead of index seeks etc.