Lidl interview question
What do you do if you have long running SQL queries?
Interview Answer
Anonymous
22 Feb 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.