This is going to top some of the weirdest things I've seen. I've tried looking up "simple t-sql delete causing timeout" but all titles are misleading, they say simple but are not. They deal with deleting millions of records or have complex relationships setup. I do not. 

I have four tables:

tblInterchangeControl,
tblFunctionalGroup,
tblTransactionSet,
tblSegment

The latter 3 all associate to tblInterchangeConrol via InterchangeControlID. There are no relationships setup. like I said as simple as one could get.

The procedure runs a delete statement on all 4 tables like so...

```
DELETE FROM tblSegment 
WHERE (ID_InterchangeControlID = @InterchangeControlID)

DELETE FROM tblTransactionSet 
WHERE (ID_InterchangeControlID = @InterchangeControlID)

DELETE FROM tblFunctionalGroup 
WHERE (ID_InterchangeControlID = @InterchangeControlID)

DELETE FROM tblInterchangeControl 
WHERE (InterchangeControlID = @InterchangeControlID)

```

The weird part is if I leave these in the procedure it times out, if I remove them, it does not. I've pinned it to these delete statements that are the cause. But Why?!

I included c# because I'm calling this procedure from a c# application. I don't think this is the issue but maybe. I only say I don't think so because my code work just fine when I remove the delete statements inside the stored procedure. Then if I put them back, an exception is thrown that it's timed out.