Enable/Disable a table to be read only on the fly
Wouldn't be nice if we can set the "read only" property of any table to be on or off easily with one simple stored procedure call?
2013-07-30
9,877 reads
Steven Rao
Dynamically Truncate a Partitioned Table
Wouldn't be great if you could truncate any partition of a partitioned table with one T-SQL statement? This article shows you how.
2013-07-11
4,789 reads
Blogs
SQL Clone Works with FILESTREAM
By Steve Jones
SQL Clone is an amazing product that virtualizes your data, allowing multiple instances to...
Fun and profit with UTF-8
When SQL Server 2019 was announced, it brought with it UTF-8 support. Also available...
Data Platform MVP 2020
I am humbled to be among so many great professionals and honored at the...
Forums
Removing TDE from a Database: Level 4 Stairway to TDE
Comments posted to this topic are about the item Removing TDE from a Database:...
Database Modeling - Relationships
Comments posted to this topic are about the item Database Modeling - Relationships, which...
Read database objects relationship in easy steps
Comments posted to this topic are about the item Read database objects relationship in...
Ask SSC