T-SQL script to purge all the tables including foreign key references. The script has been made smart enough to use TRUNCATE wherever there is no foreign key reference and to use DELETE wherever there is foreign key reference.
2019-12-10
1,801 reads
By Jen McCown
Friends, the MidnightDBAs have a plan for 2022. A capital-P Plan. And it involves...
By Steve Jones
I was doing a little work with CosmosDB recently, and there were a few...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hi All I have 1 TB database and i cant shrink it as it...
Hello, I have a Windows 2019 machine. I have SQL Server 2016 and the...
Ask SSC