• Are you deleting one row or a range or rows?

    Also, is the selectivity of the delete operation covered by an index?

    For example, if you DELETE FROM TABLEA WHERE NAME = 'SMITH', and the NAME column is not indexed, then SQL Server will potentially hold an update lock on every page in the table, rather than just the page containing the individual row to be deleted.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho