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
14,326 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,755 reads
Blogs
Daily Coping 30 Sep 2022
By Steve Jones
Today’s coping tip is to find a new way to use one of your...
Why You Need Presentation Skills
And no, the answer is not because you want to be a Microsoft MVP....
Daily Coping 29 Sep 2022
By Steve Jones
Today’s coping tip is to avoid saying “I should” and make time to do...
Forums
TCP Provider: A connection attempt failed for target server
Hi. In source SQL Instance target linked server has been created and connection tested...
Get Part number and display in Header
Hello, so I have a part number, and I want to display it in...
BlobColumn to String
I have this column in sql server that has value of "dog,cat,mouse" so I...
Ask SSC