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
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)
796 reads
2014-09-11
2,326 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)
26,253 reads
Blogs
The 99 Flavours of SQL Server are all Vanilla
There are so many options for running SQL Server now. It can feel a...
Why do DBAs dislike loops?
If you started out as a developer you were probably taught how important loops...
Public and Demo Data Coming Soon!
Any database professional that has been around the Microsoft world for more than about...
Forums
deadlock issue
Hi Experts, We are seeing repeated deadlocks on one of our prod servers. Can...
Waits and Queues
Comments posted to this topic are about the item Waits and Queues
Synonyms for Tables
Comments posted to this topic are about the item Synonyms for Tables
Ask SSC