Looking at the code and just spitballing an idea, if you order the data by Name first and by ID second, you can use lead to see if the length...

• This reply was modified 4 years, 2 months ago by Mr. Brian Gale. Reason: added some code
• This reply was modified 4 years, 2 months ago by Mr. Brian Gale.

First question - what have you tried?

To me, unless I am misunderstanding it, this sounds pretty easy using windowing functions to handle the first 1/2 and then the total becomes...

This is actually pretty easy to do based on what you put there.  Step 1, set Saturday as your start date by running:

SET DATEFIRST 6

Next, you are...

Before doing a trigger, may not hurt to look at other options.  Extended events for example.

Triggers can be painful if you forget to drop them when you are done.

Are the indexes created before or after populating the data?  I would encourage you to create them AFTER populating the data OR rebuild them after populating the data.

Backups don't modify...

My understanding - that shouldn't ever happen.

If the data isn't changing, the data shouldn't be getting fragmented.  INSERT, UPDATE, and DELETE operations would cause fragmentation, SELECTs shouldn't.

My guess - something...

I am pretty sure that SSMS doesn't include dtexec, but your coworker could confirm this by running dtexec outside of excel.  You listed the command that excel is trying to...

My preference is option 1 because then the command will write all the output PLUS the errors to the log file.  It also allows you to have 2 logs -...

What 3rd party database backup tool are you using and where is it writing the backups to?

I personally like having my backups available for me to restore to test systems...

NOTE - I do not use AG's nor have I configured them before.  I am just replying based on my interpretation of the errors you have.

If memory serves, the logins...

Does your coworker have dtexec installed?  If not, he can't run something doesn't exist on his system.

I would start out by looking at the error messages.  If it works for...

This is one of those "it depends" situations.  According to the Microsoft documentation (found here https://docs.microsoft.com/en-us/previous-versions/dotnet/framework/data/adonet/sql/managing-permissions-with-stored-procedures-in-sql-server), it states:

Stored procedures take advantage of ownership chaining to provide access to data so...

Personally, I don't like that security model as I like working with a "least privilege" model.  I generally apply permissions as part of my object creation scripts.

Now, if you DO...

Step 1 - check the logs.

I would probably reach out to the server admins (and check the logs) to determine why starting the service as a user other than the...

As a random guess - I would say that in the presentation, entityID was an INT IDENTITY(1,1) and in your code, it doesn't seem to be an IDENTITY type.  So...