Can you prevent deletes and inserts without a WHERE clause from running?
Erik writes a script to do what it says on the tin.
2018-01-01
4,692 reads
Erik writes a script to do what it says on the tin.
2018-01-01
4,692 reads
Atul Gaikwad details the differences between DELETE and TRUNCATE, including how they vary in terms of being rolled back.
2016-05-18
4,518 reads
How to delete millions of rows with virtually no contention.
2015-09-04 (first published: 2013-03-06)
27,136 reads
Learn how you can build triggers that prevent an update or delete statement from being run without a WHERE clause in this article.
2013-08-09 (first published: 2011-01-25)
16,687 reads
Used to generate Select/Delete scripts. It does NOT run them.
You need to copy the output of this script to a new window and run it manually.
2008-08-06
548 reads
This article explains the differences between the Truncate and Delete commands in SQL Server.
2019-09-18 (first published: 2007-11-22)
35,517 reads
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers