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
947 reads
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 reads
By James-Serra
As a followup to my blog post Azure Data Lake Store Gen2 is GA,...
As always, the scripts in this post can also be found on our Git...
I ran into a rather obscure permissions problem the other day. Since I wasn’t...
I want to send an email if the table in SQL hasn't been update...
All, Up to this point I've only worked with relational databases. I'm trying to...
What is the recommendations for backups in distributed availability groups? I have AG setup...
Ask SSC