What do you do if you have long running SQL queries?
Utilisateur anonyme
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.