Truncate tables where Referential Integrity exists
This script can be useful in test and dev environments to quickly clear tables via the truncate command where referential integrity exists.
2024-05-15 (first published: 2024-05-02)
855 reads
Truncate
2023-10-16
554 reads
New Truncation Error Message in SQL Server 2019
A new error message in SQL Server 2019 will make your life much easier!? Learn more...
2019-03-05
3,244 reads
Truncate tables with foreign keys
Truncating tables with constraints always had been a pain, since we have to drop and recreate all the FKs. I created a script that takes care of dropping and recreating the foreign keys while truncating. Please use with caution! and always respect your Data !
2016-12-01 (first published: 2016-11-28)
1,417 reads
2014-09-11
2,391 reads
Who Truncated That Table and What Do I Do Now?
This article describes a way to identify the user who truncated the table & how you can recover the data.
2015-02-20 (first published: 2014-06-05)
34,833 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
Alamat BCA KCP Ciceri Telp:0821°8200°233
Telp/Wa 628218200233 Jl. Jend. Sudirman No.38, Sumurpecung, Kec. Serang, Kota Serang, Banten 42118
Alamat BCA KCP Citra Raya Telp:0821°7555°651
Telp/Wa 628217555651 Perumahan Citra Raya Blok KD.02 No. 10, 15, RW.Mardigrass, Mekar Bakti, Kec....
MiniMax m3 and SQL Server
Comments posted to this topic are about the item MiniMax m3 and SQL Server
Question of the Day
SQL Server Vector Support I
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers