Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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 | 6,919 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 | 3,742 reads
   Items 1 to 2 of 2