2022-10-24
599 reads
2022-10-24
599 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)
28,349 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,914 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
578 reads
This article explains the differences between the Truncate and Delete commands in SQL Server.
2019-09-18 (first published: 2007-11-22)
37,073 reads
By Andy Warren
Somehow two years have elapsed since my last update; hopefully it won’t be that...
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
I have table: t1 in schema1 with 19 billion records. I have another table...
Comments posted to this topic are about the item Minimally Viable Security
Comments posted to this topic are about the item Encoding NULL
What is returned from this code in SQL Server 2025?
SELECT BASE64_ENCODE(NULL)See possible answers