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-11-11 (first published: 2019-10-31)
596 reads
By Vinay Thakur
Here are the different ways to know the tlog file related information sys.dm_db_log_stats –...
By Will Assaf
Thanks to everyone who joined the BRSSUG for a night all about SQL Server...
By Gerard
This is the third post in a series about modern Data Lake Architecture where...
Hi All, I'm pretty new to azure and am hitting the following problem. I've...
Hi, Our client have MS-Access database which has more queries written in MS-Access 2010...
Index maintenance and loading data conflict with each other cause the log file to...
Ask SSC