Obsoleting Unused SSRS Reports
Learn about programmatically obsoleting unused SSRS reports from your Report Server.
2020-01-10 (first published: 2017-04-26)
11,920 reads
Amarendra Reddy Thummeti
The OUTPUT Clause for INSERT and DELETE Statements
In this article, I will provide a set of examples to show case the use of OUTPUT clause for INSERT and DELETE statements.
2019-03-15 (first published: 2017-05-25)
64,287 reads
The OUTPUT Clause for the MERGE Statements
In this article, I will provide a set of examples to showcase the use of OUTPUT clause within the MERGE statement and how to capture the OUTPUT clause results into an archive table.
2019-03-08 (first published: 2017-06-08)
34,515 reads
The OUTPUT Clause for UPDATE Statements
In this article, I will provide a set of examples to showcase the use of OUTPUT clause in capturing the results of the updated rows into a table variable for the UPDATE statements.
2017-06-06
35,172 reads
Blogs
Azure Storage tips
By James-Serra
As a followup to my blog post Azure Data Lake Store Gen2 is GA,...
Managing Agent Jobs on Availability Group Servers
As always, the scripts in this post can also be found on our Git...
Permissions required for row counts to show up on Object Explorer Details
I ran into a rather obscure permissions problem the other day. Since I wasn’t...
Forums
Sql server Express 2017 and ssms
Hi all, I've never used mssql express before but we had a small intranet...
Memory requirement
Looking for memory optimized tables. How would we know that the approx memory is...
Question on the use of schemas for access control
I know that this is a long article, so, I totally understand if there...
Ask SSC