SQL Server Performance Office Hours Episode 31 Questions: I have a very slow delete statement (44 mins for 2000 records). Execution plan shows painful Clustered Index Delete is culprit. Parent and child foreign keys are indexed on two associated tables. Where else to look? Merge join is feeding problematic operator but associated sort isn’t causing […] The post SQL Server Performance Office Hours Episode 31 appeared first on Darling Data.
