Obsoleting Unused SSRS Reports
Learn about programmatically obsoleting unused SSRS reports from your Report Server.
2020-01-10 (first published: 2017-04-26)
15,316 reads
Amarendra Reddy Thummeti
- Interests: SQL Server, Databases , BI tools
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)
288,642 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)
157,270 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
181,507 reads
Blogs
AI Helping with an API
By Steve Jones
Can an AI help me with some database API work? Let’s see. This is...
Creating a “Real” Copy of a View: #SQLNewBlogger
By Steve Jones
I saw a post where a developer was trying to read the Information Schema...
T-SQL Tuesday #181: A Technology Present
By Steve Jones
It’s the last T-SQL Tuesday of the year, and it’s amazing to think we’ve...
Forums
Query is filling Tempdb
I have query which is filling TEMPDB I need suggestion how to modify this...
Script is filling Tempdb
I have query which is filling TEMPDB I need suggestion how to modify this...
Date data type not recognized with oledb type provider
Hello, We recently made the following observation working with VS2022 combined with the SSIS...
Question of the Day
The Hash Join III
In a hash join, if all the build input does not fit in memory, what type of hash join is this?
See possible answers