Home Forums SQL Server 2008 SQL Server 2008 - General DELETE FROM Table WHERE PKID = 0 -runs for over 5 min without completing RE: DELETE FROM Table WHERE PKID = 0 -runs for over 5 min without completing

  • July 24, 2013 at 2:04 pm

    #1635516

    Is there a foreign key constraint, where this table is referenced?

    It looks like it may be doing a cascading delete on another large table.

    CXPACKET wait indicates paralellism.