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
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
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
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Andy Warren
I drove up to Jacksonville Friday afternoon to allow for bad traffic and immediately...
This months subject for T-SQL Tuesday was Your first technical job. I have to...
Hi, Whenever I get an high cpu alert , be it non-working hours or...
I am using .LDF file to get the information about when was DB last...
Ahoi, we are using the ola hallengren scripts to run the weekly index optimizer....