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
13,885 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
5,622 reads
Blogs
Daily Coping 24 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Notes on SQLSaturday Jacksonville 2022
By Andy Warren
I drove up to Jacksonville Friday afternoon to allow for bad traffic and immediately...
TSQL Tuesday #150: Your first technical job. Rollup.
This months subject for T-SQL Tuesday was Your first technical job. I have to...
Forums
Logging sql stms into a table when there is a High cpu alert
Hi, Whenever I get an high cpu alert , be it non-working hours or...
Transactions names meaning In Transaction Logs
I am using .LDF file to get the information about when was DB last...
Iterate and reorganize subset of database tables
Ahoi, we are using the ola hallengren scripts to run the weekly index optimizer....
Ask SSC