SQLServerCentral / Discuss Content Posted by Gregory Larsen / Article Discussions / Article Discussions by Author / Stairway to T-SQL DML Level 11: How to Delete Rows from a Table / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 10:28:13 GMT20RE: Stairway to T-SQL DML Level 11: How to Delete Rows from a Tablehttp://www.sqlservercentral.com/Forums/Topic1288765-90-1.aspxGood article, thank you.One small thing, and it's nothing to do with the thrust of the article, but could people stop using 'criteria' when they mean the singular. It's 'a criterion', 'many criteria'.Tue, 02 Oct 2012 02:11:12 GMTmarlon.setonRE: Stairway to T-SQL DML Level 11: How to Delete Rows from a Tablehttp://www.sqlservercentral.com/Forums/Topic1288765-90-1.aspxTRUNCATE can actually be rolled back. See my recent thread here:http://www.sqlservercentral.com/Forums/Topic1361513-1292-1.aspxThu, 20 Sep 2012 09:39:19 GMTChrissy321RE: Stairway to T-SQL DML Level 11: How to Delete Rows from a Tablehttp://www.sqlservercentral.com/Forums/Topic1288765-90-1.aspx...and like most other DML actions:Always wrap the commands in USE [database]; BEGIN TRAN...COMMIT/ROLLBACK TRAN.Won't be of much use with TRUNCATE TABLE but transaction control is always important when modifying data.Wed, 19 Sep 2012 21:11:52 GMTJoe-10953RE: Stairway to T-SQL DML Level 11: How to Delete Rows from a Tablehttp://www.sqlservercentral.com/Forums/Topic1288765-90-1.aspxhttp://dbace.us/repriser/sqlpass/DeleteLargeWithBatch.htmWed, 19 Sep 2012 13:15:21 GMTjswong05RE: Stairway to T-SQL DML Level 11: How to Delete Rows from a Tablehttp://www.sqlservercentral.com/Forums/Topic1288765-90-1.aspxNo 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.Wed, 19 Sep 2012 08:14:00 GMTWBarriosRE: Stairway to T-SQL DML Level 11: How to Delete Rows from a Tablehttp://www.sqlservercentral.com/Forums/Topic1288765-90-1.aspxExcellent article. Thanks.Perhaps this is an obvious point, but we always write our "DELETE" statements as "SELECT" statements first. Then we can check exactly what rows we are going to delete. Then generally it's fairly trivial to change the select to the delete. Obviously you can't always do this. Thanks again.Wed, 19 Sep 2012 02:51:47 GMTandrew.robertsonRE: Stairway to T-SQL DML Level 11: How to Delete Rows from a Tablehttp://www.sqlservercentral.com/Forums/Topic1288765-90-1.aspxSmall typo: Listing 10 creates a CTE called DupRecords, while the description afterward refers to it as DupColor. Also, doesn't the partition mean that the ROW_NUMBER() applies for duplicate Names [i]and[/i] Ids? The listing code matches your earlier statement that 'a duplicate row is a row that has the same column value for each and every column' but the discussion only refers to Name, not Name and Id.Tue, 18 Sep 2012 21:26:19 GMTluke.warnemindeStairway to T-SQL DML Level 11: How to Delete Rows from a Tablehttp://www.sqlservercentral.com/Forums/Topic1288765-90-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Stairway+Series/90219/">Stairway to T-SQL DML Level 11: How to Delete Rows from a Table</A>[/B]Tue, 24 Apr 2012 04:07:02 GMTGreg Larsen