SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Guest Columnist: Steven Rao

SQLServerCentral.com profile

   Items 1 to 2 of 2   

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?  Read more...
By Steven Rao 2013/07/30 | Source: SQLServerCentral.com | Category: read only
Rating: |  Discuss |   Briefcase | 7,076 reads

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.  Read more...
By Steven Rao 2013/07/11 | Source: SQLServerCentral.com | Category: partition switch
Rating: |  Discuss |   Briefcase | 4,034 reads
   Items 1 to 2 of 2