Which part is slow?  The loading of Excel into the staging table or merging the staging table into the live table?

You are using SSIS.  How much memory does...

I just ran the above code with minor modifications and it ran without any problems.
The modification I did was to change it from a permanent table to a table...

I try to own the mistake if it was me who made it and I use that to update our release documents to prevent it from happening in the future...

This line looks a bit odd to me too:
SET @TABLE_NAME = (SELECT...

I am slightly confused.
I took the code, copy-pasted it into SSMS 2016, connected to a SQL 2016 SP1 instance and ran it.  I got a different answer than the...

As a thought, does this query give you any results:
SELECT *
FROM tblA
WHERE tblA.id NOT IN (SELECT id
     FROM tblB)

July 12, 2017 at 4:03 pm

#1950657

May actually have a solution for you:
https://support.microsoft.com/en-us/help/3053960/fix-a-system-assertion-in-longrec.inl-1318-occurs-when-you-rebuild-or

I see you posted this in the SQL 2016 section and the above article applies to SQL 2012.  I'm guessing...

The other thing you can do is go into the SSRS web portal, navigate to the folder that has the reports to remove, change the view type to "list" instead...

2 things come to mind:
1 - did you run DBCC CHECKDB to ensure the database is not corrupt?
2 - did you check the SQL Server error log for...

Another thing to watch, if you are using an SSIS catalog (might apply to the non-catalog method too), the job doesn't need to reside on the same server as the...

Adding to what has been said, I am slightly confused as to why you would manage the subscriptions for end users.
I understand if the subscriptions are emails being sent...

Adding to Sue's response, if user XXXX doesn't explicitly exist in your database, but is a windows user, they could be a member of an AD group that has permission...

There are a lot of cool things you can do with the filestream and filetables though that you can't do nicely in windows.  Full text searching of file contents for...