Create a proxy account that has the necessary rights/permissions to perform this function.  Permissions need to be defined in SQL Server and the file system - and a proxy account...

FWIW - I use an extended event on my system to capture any queries that take longer than 2 seconds to execute.  I have the extended event set up to...

If you have embedded characters on one side - comparing will not be equal.  You need to remove those characters for the match to be valid.

I would think you would...

If you performed a backup/restore - the new file that was created during that process will be minimally fragmented (file system).  This does nothing for internal index fragmentation (of course).

You...

It really isn't a good idea to put backups on the same drive/location as your data/log files.  Not only will that cause performance issues - but if you lose that...

You can use CROSS APPLY for this:

Declare @clinicID int = 500;

 Select *
   From #TItems          ...

Is this what you are looking for?

https://marketplace.visualstudio.com/items?itemName=ProBITools.MicrosoftRdlcReportDesignerforVisualStudio-18001&ssr=false#qna

What utility is used to load the data?  If it is SSIS then you can control the batch/commit sizes on the OLEDB Destination so the transactions don't grow the log...

I think you are looking in the wrong place - SSMS does not access files on the server to run any reports.  You need to look at permissions on your...

You can do this all in a single assignment:

Declare @cases Table (id int, ApplicationStatusEntityID int);
 Insert Into @cases (id, ApplicationStatusEntityID)
 Values (1, 3)
    ...

• This reply was modified 6 years, 12 months ago by Jeffrey Williams. Reason: Included check for attribution entity id in second example

It isn't clear from the sample data - what is your expected results?

I think you are looking for either an outer join - or a recursive CTE...here is an example...

You don't need to convert to XML to perform the split:

Declare @testSplit Table (
        ID int
    ...

Is the Java app calling a stored procedure to load the table - or is it all embedded code in the application?

Why is this process failing and why is that...

Setup a proxy account using the domain windows account added to your DBA group.  Then set the job steps to run using that proxy account.

No need to change the service...

The stored procedure that is used by the maintenance task checks the file(s) to be deleted are from the instance where the job is running - and validates the files...