2022-10-24
589 reads
delete
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
Differences between Delete and Truncate in SQL Server
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
Hidden Tricks To SQL Server Table Cleanup
How to delete millions of rows with virtually no contention.
2015-09-04 (first published: 2013-03-06)
28,270 reads
Automated Trigger To Require a WHERE Clause
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,876 reads
Delete records in all related tables
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
564 reads
The Difference between Truncate and Delete in SQL Server
This article explains the differences between the Truncate and Delete commands in SQL Server.
2019-09-18 (first published: 2007-11-22)
36,853 reads
Blogs
AI Step 1
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
Beginner’s Guide: Building a Dockerized Todo App with React, Chakra UI, and Rust for Backend
In a containerized app, React and Chakra UI provide a robust and accessible user...
A New Word: Nachlophobia
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
Forums
Call dynamic sql storedprocedure from SSIS execute sql task
hi, I have a table called Rules Create table Rules ( Id int ,...
Migrating database with many orphan users.
I am currently upgrading a very old database running SQL Server 2008 to SQL...
Active and Active Cluster
Hi Team, I am planning to apply security updates for SQL Server 2016 on...
Question of the Day
The Funny SELECTs
What is returned from this query?
SELECT
( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2011' AND soh.OrderDate < '01/01/2012') AS OrdersIn2011
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2012
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2013; See possible answers