Is your msdb data or log file full?

Do you see any errors in the SQL error log that could be related to the issue?

Agree with Ken.  Use a trigger to only write the data you want in the table to begin with.

The only thing Ken left out was a:

SET NOCOUNT ON

at the start...

You didn't provide any sample data, so I can't test my code, but something like this should do what you need:

SELECT COUNT(*) AS DayCount

,YEAR(myDateTime) AS Year
,MONTH(myDateTime) AS...

When you create the proc, you would need to specify EXEC AS OWNER, making sure the OWNER is a high-level user.

When you just give permission to EXEC the proc, the...

Yes.  The format is fixed, with the dashes always in the same locations.

I suggest creating the following indexes to support the query.  If you'd like to adjust other indexes on the tables also, just let me know.

CREATE...

If you can, review the query plan to verify that those indexes are actually being used.  Without a query plan, we can't tell for sure.

I suggest creating the following indexes to support the query.  If you'd like to adjust other indexes on the tables also, just let me know.

CREATE...

I suggest creating the following indexes to support the query.  If you'd like to adjust other indexes on the tables also, just let me know.

CREATE UNIQUE NONCLUSTERED...

One of the tables you're joining to must have an extra matching row in it compared to what you were used to seeing.  I can't tell which one from what...

Would you give us actual table data -- i.e. CREATE TABLE and INSERT statement with VALUES -- rather than just a picture?  We can't write SQL against a picture :-).

This...

Hmm, interesting.  Lots of indexes there, so we'll need to do a full analysis, if you're willing.  Please run the attached query and post the results in some type of...

Adding a running number can add records if before the column addition there were duplications that were shown only once but after the column addition they stopped being duplications. ...

I can't offer index recommendations without seeing the DDL for the tables, including all current index definitions.  The most critical index is the clustered index, so that should be determined...

I typically use SSIS to do that, since it has the inherent capability to run multiple imports async.