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,148 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,530 reads
By Zikato
Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Foreword In the second part of this...
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
Now that your CFS has been setup it’s time to get the word out...
Hi guys I have a query with a SELECT statement, that joins 2 other...
Hi all, Can someone please help Pivot a table. The table currently looks like...
Hello Community, Can someone please help transpose a table. The table currently looks like...