Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Gregory Larsen Stairway to T-SQL DML Level 11: How to Delete Rows from a Table RE: Stairway to T-SQL DML Level 11: How to Delete Rows from a Table

  • September 19, 2012 at 8:14 am

    #1539591

    No mention of contention issues?

    What happens when you have to delete 100K records from 100M record table in an OLTP environment? What happens when SQL server decides to escalate the locking to the table level? It hurts.

    Discussing these considerations would really push the article to the next level.